Menu

#1 Enable dots in the column names

open
nobody
None
5
2012-12-07
2004-12-27
No

We use SQL to query the list of java objects rather than
an ordinary database. The column names are mapped
into the object fields.

Currently JSqlParser allows only single dot, separating
the table name from the column name. The java object
can have much more nested objects.

The simpliest solution would be to recognise the first dot
as the table/column separator, but add all subsequent
dots to the returned column name. This feature should
be optional, having possibility to turn it on and off, for
example, by the boolean getter and setter in
CCJSqlParserManager.

The possible workaround in to pre-process the query,
replacing dot by, for example, '$'. The problem is that
dots can also occur in fload values (where a=5.0) and
string literals (where chapter="1.2.2"), where they
should be preserved. So pre-processing is not promising
to be simple.

Discussion