user_guide.md

Exasol SQL Statement Builder User Guide

You can follow this guide to learn more about how to use the SQL Statement Builder. It provides explanations of currently supported features with various code examples.

Overview

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 errors and security risks.

SQL Statement Builder allows users to create an abstract representation of SQL statements using fluent programming. Once you have such an abstract statement, you can, for example, use the various renderers provided by this project to render the statement into an SQL string.

Currently Supported SQL Statements

Data Definition Language (DDL)

• CREATE SCHEMA
• DROP SCHEMA
• CREATE TABLE
• DROP TABLE

Data Query Language (DQL)

• SELECT

Data Modification Language (DML)

• INSERT
• MERGE