sqlite-simple-0.4.19.0: Mid-Level SQLite client library
Copyright(c) 2011-2012 Leon P Smith
(c) 2018 Janne Hellsten
LicenseBSD3
MaintainerJanne Hellsten <jjhellst@gmail.com>
Portabilityportable
Safe HaskellSafe-Inferred
LanguageHaskell2010

Database.SQLite.Simple.QQ

Description

The sql quasiquoter, for writing large SQL statements.

Synopsis

Documentation

sql :: QuasiQuoter Source #

A quasiquoter for writing big SQL queries.

One should consider turning on the -XQuasiQuotes pragma in that module:

{-# LANGUAGE QuasiQuotes #-}

myQuery = query conn [sql|
    SELECT
      *
    FROM
      users
    WHERE jobTitle = ?
    |] jobTitle