stazz / java-sql-generator Goto Github PK

Currently SQLVendor provides read-only API for its services. It should be possible to customize it more by adding custom factories and processors.

Seems odd that LIMIT would only be within the pgsql API, given that it's hardly the only database to support it -- e.g. MySQL has supported both LIMIT and OFFSET for years, and not having LIMIT support can result in some ridiculously inefficient queries.

Currently there are no arithmetic expressions. Implement the API and implementation for these.

It is good to know which vendor some SQLStatement came from.

Currently the tests of Java-SQL-Generator mainly create some SQL statement and output it to log. Any exception raised during the test will fail it, however, the actual generated contents are never checked to hold. Make the tests actually validate the contents of the generated SQL string. Additionally, implement a lot more tests to cover all provided functionality.

Currently it is not very easy to create even really simple queries. Introduce some kind of "SimpleQueryBuilder", which provides light-weight support for building SIMPLE queries (ie, no need to support all kinds of complex features, just a sub-set of existing ones).

Introduce support for CREATE and DROP statements before 0.2 release.

Make the strings produced by java-sql-generator take into account the possiblity for SQL injection.

Right now, in order to select all columns, one has to do 'select("*")' in the SimpleQueryBuilder. The builder should be extended with "selectAll()" method, which marks that the query should select all columns, without the need of using string literals.

I have been thinking for some time about generating EDSLs from BNF. Do you have any thoughts on this?

br,
Matt

Some things may seem really non-extensible in SQL 99 BNF document, yet some RDB vendors provide extensions to them. Currently, some things are defiend using enum keyword. Make all enum values into strings so that they may be extended more easily.

Hi Stan,

I would like to create table columns with the following definition:

"my_pk_column BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY"

I did not found any way to do so in current version, tell me if I'm wrong.

/Paul