Skip to content

Consider abstracting away the writer SQL statement generation to support other database SQL formats #6

Open
@iamgollum

Description

@iamgollum

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.

Metadata

Metadata

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions