Database.HsSqlPpp.Quote

A quasiquoter for SQL. Antiquoting is a bit inconsistent. The splice variable names must be all lower case because of a limitation in the parser.

Example:

import Database.HsSqlPpp.Ast
import Database.HsSqlPpp.Quote
import Database.HsSqlPpp.Annotation

test :: Statement
test = [$sqlStmt|

  create table $(tablename) (
   $(varname) $(typename)
  );

        |]
  where
    tablename = "my_table"
    varname = "my_field"
    typename = "text"

See http://jakewheat.github.com/hssqlppp/QuasiQuoteTests.html for more simple examples

Documentation

sqlStmts :: QuasiQuoter

quotes Statements

sqlStmt :: QuasiQuoter

quotes a single Statement

pgsqlStmts :: QuasiQuoter

quotes plpgsql Statements

pgsqlStmt :: QuasiQuoter

quotes a plpgsql Statement

sqlExpr :: QuasiQuoter

quotes a ScalarExpr