stch.sql.format — stch-library/sql 0.1.4

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

*clause* clj

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

*fn-context?* clj

*input-params* clj

*param-counter* clj

*param-names* clj

*params* clj

Will be bound to an atom-vector that accumulates SQL parameters across possibly-recursive function calls

*quote-identifier-fn* clj

*subquery?* clj

clause-order clj

Determines the order that clauses will be placed within generated SQL

expand-binary-ops clj

(expand-binary-ops op & args)

fn-aliases clj

fn-handler clj multimethod

format clj

(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]

format-clause clj multimethod

Takes a map entry representing a clause and returns an SQL string

format-join clj

(format-join type table pred)

format-predicate clj

(format-predicate pred & {:keys [quoting]})

Formats a predicate (e.g., for WHERE, JOIN, or HAVING) as a string.

format-predicate* clj

(format-predicate* pred)

infix-fns clj

known-clauses clj

quote-identifier clj

(quote-identifier x & {:keys [style split] :or {split true}})

sqlable? clj

(sqlable? x)

to-sql clj

(to-sql x)

ToSQL clj protocol

-to-sql clj

(-to-sql x)