stazz / java-sql-generator Goto Github PK
View Code? Open in Web Editor NEWA framework to generate syntactically correct SQL statements in a typesafe, easy, and uniform way (without StringBuilders).
A framework to generate syntactically correct SQL statements in a typesafe, easy, and uniform way (without StringBuilders).
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
Currently SQLVendor provides read-only API for its services. It should be possible to customize it more by adding custom factories and processors.
It is good to know which vendor some SQLStatement came from.
Make the strings produced by java-sql-generator take into account the possiblity for SQL injection.
I have been thinking for some time about generating EDSLs from BNF. Do you have any thoughts on this?
br,
Matt
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).
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.
Introduce support for CREATE and DROP statements before 0.2 release.
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.
Currently there are no arithmetic expressions. Implement the API and implementation for these.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.