stch.sql.format documentation

Format query and DML statements. Use with stch.sql.

*clause*

During formatting, *clause* is bound to :select, :from, :where, etc.
Source

*fn-context?*

Source
*input-params*
Source
*param-counter*
Source
*param-names*
Source
*params*
Will be bound to an atom-vector that accumulates SQL parameters across
possibly-recursive function calls
Source
*quote-identifier-fn*
Source
*subquery?*
Source
-to-sql
(-to-sql x)
Source
ToSQL
Source
clause-order
Determines the order that clauses will be placed within generated SQL

Source
expand-binary-ops
(expand-binary-ops op & args)
Source
fn-aliases
Source
fn-handler
Source
format
(format sql-map & params-or-opts)
Takes a SQL map and optional input parameters and returns a vector
of a SQL string and parameters, as expected by clojure.java.jdbc.

Input parameters will be filled into designated spots according to
name (if a map is provided) or by position (if a sequence is provided).

Instead of passing parameters, you can use keyword arguments:
  :params - input parameters
  :quoting - quote style to use for identifiers; one of :ansi (PostgreSQL),
             :mysql, :sqlserver, or :oracle. Defaults to no quoting.
  :return-param-names - when true, returns a vector of
                        [sql-str param-values param-names]
Source
format-clause
Takes a map entry representing a clause and returns an SQL string

Source
format-join
(format-join type table pred)
Source
format-predicate
(format-predicate pred & {:keys [quoting]})
Formats a predicate (e.g., for WHERE, JOIN, or HAVING) as a string.

Source
format-predicate*
(format-predicate* pred)
Source
infix-fns
Source
known-clauses
Source
quote-identifier
(quote-identifier x & {:keys [style split], :or {split true}})
Source
sqlable?
(sqlable? x)
Source
to-sql
(to-sql x)
Source