Open
Description
Observation
Currently the code base is designed to support different relational databases. However, some of these have different SQL flavors that would need to be supported: http://troels.arvin.dk/db/rdbms/
For example,
Postgres
INSERT INTO tablename
VALUES (0,'foo') , (1,'bar') , (2,'baz');
Oracle
INSERT ALL
INTO tablename VALUES(0,'foo')
INTO tablename VALUES(1,'bar')
INTO tablename VALUES(2,'baz')
Action Item
Create a small version of something like this: https://examples.javacodegeeks.com/core-java/sql/jdbc-query-builder-tutorial/
Consider linking the DatabaseType
to a "SQL Statement Syntax Builder" of some kind to support the different syntax requirements.