SQL Statement Builder
The Exasol SQL Statement Builder abstracts programmatic creation of SQL statements and is intended to replace ubiquitous string concatenation solutions which make the code hard to read and are prone to error and security risks.
Goals:
- Foster clean and readable code
- Allow for thorough validation of dynamic parts
- Detect as many errors as possible at compile time
- Don't repeat yourself (DRY)
- Allow extension for different SQL dialects
In a Nutshell
The following example gives you an idea about what you can do with the SQL Statement Builder. Check our user guide for more details.
Select select = StatementFactory.getInstance().select()
.field("fieldA", "tableA.fieldB", "tableB.*");
select.from().table("schemaA.tableA");
select.limit(10);
StringRendererConfig config = StringRendererConfig.builder().quoteIdentifiers(true).build();
SelectRenderer renderer = new SelectRenderer(config);
select.accept(renderer);
String sql = renderer.render();
.field("fieldA", "tableA.fieldB", "tableB.*");
select.from().table("schemaA.tableA");
select.limit(10);
StringRendererConfig config = StringRendererConfig.builder().quoteIdentifiers(true).build();
SelectRenderer renderer = new SelectRenderer(config);
select.accept(renderer);
String sql = renderer.render();
Table of Contents
Information for Users
"Users" from the perspective of the sql-statement-builder are developers integrating the module into their own software.