11.38 text.sql - SQL parsing and construction

Module: text.sql

This module provides a utility to parse and construct SQL statement.

It is currently under development, and we only have a tokenization routine. The plan is to define S-expression syntax of SQL and provides a routine to translate one form to the other.

Note: If you're looking for a routine to escape strings to be safe in SQL, see dbi-escape-sql in DBI user API.

Function: sql-tokenize sql-string

Tokenize a SQL statement sql-string. The return value is a list of tokens, where each token is represented by one of the following forms.

<symbol> Special delimiter. One of the followings: + - * / < = > <> <= >= || <character> Special delimiter. One of the followings: #\, #\. #\( #\) #\; <string> Regular identifier (delimited <string>) Delimited identifier (parameter <num>) Positional parameter (?) (parameter <string>) Named parameter (:foo) (string <string>) Character string literal (number <string>) Numeric literal (bitstring <string>) Binary string. <string> is like "01101" (hexstring <string>) Binary string. <string> is like "3AD20"

If it encounters an untokenizable string, it raises an <sql-parse-error> condition.

Condition: <sql-parse-error>

A condition to indicate an SQL parse error. Inherits <error>.

Instance Variable of <sql-parse-error>: sql-string

Holds the source SQL string.

This document was generated by Shiro Kawai on October, 7 2008 using texi2html 1.78.