The Symbolic SQL Syntax


CLSQL provides a symbolic syntax allowing the construction of SQL expressions as lists delimited by square brackets. The syntax is turned off by default. This section describes utilities for enabling and disabling the square bracket reader syntax and for constructing symbolic SQL expressions.

Tip: just want it on

file-enable-sql-reader-syntax at the top of each file is easiest.

Table of Contents

ENABLE-SQL-READER-SYNTAX — Globally enable square bracket reader syntax.
DISABLE-SQL-READER-SYNTAX — Globally disable square bracket reader syntax.
LOCALLY-ENABLE-SQL-READER-SYNTAX — Locally enable square bracket reader syntax.
LOCALLY-DISABLE-SQL-READER-SYNTAX — Locally disable square bracket reader syntax.
RESTORE-SQL-READER-SYNTAX-STATE — Restore square bracket reader syntax to its previous state.
FILE-ENABLE-SQL-READER-SYNTAX — Enable the square bracket reader syntax for the duration of the file.
SQL — Construct an SQL string from supplied expressions.
SQL-EXPRESSION — Constructs an SQL expression from supplied keyword arguments.
SQL-OPERATION — Constructs an SQL expression from a supplied operator and arguments.
SQL-OPERATOR — Returns the symbol for the supplied SQL operator.