Instantiates a new QRY
object, unless otherwise specified
if false
, does NOT instatiate the QRY
An instatiated QRY
object, unless otherwise specified
Begin a SELECT
statement
The columns to SELECT
The QRY
instance chain
Begin a INSERT
statement
The table recieving INSERTS
The columns recieving VALUES
The QRY
instance chain
Begin a UPDATE
statement
The table recieving UPDATES
An optional identifer
and database
for the table
The QRY
instance chain
Begin a DELETE
statement
The QRY
instance chain
Creates a regex
pattern to match a query-template placeholder
The placeholder's name
The regex
pattern
Takes a query-template and replaces the placeholders
with the values specified
An SQL
query-template. This utilizes :NAME:
placeholders
The values to place into the query
The formatted SQL
query
Formats a clause for use in a SQL
query
The column-name this clause pertains to
The comparison operator (=|IN|EXISTS|REGEXP|...)
The value the column should conform to
The type of clause (WHERE|AND|OR)
The formatted SQL
clause
A default type-parser for SQL result columns
A MySQL
.Field
object
The next Field
The next field's parser
Restricts a pagination object to positive numbers and any specified thresholds
A pagination object, specifying a page number & result limit
The page & number restrictions for the object
The restricted pagination object
A reducer, which filters, coalesces, converts (transforms), and joins delimited string to build a complex query-clause
Either a string or array of strings to include in the clause. Each subsequent filter/coalesce/converter will be applied to each string
A TFilter
that will trickle down to the matching index of the coalesce
/converter
A TCoalesce
objects that will trickle down to the matching index of the converter
A CBConvert
to handle custom transformations matching the index of the corresponding filter
object.
The transformed query-clause
A reducer, which filters, coalesces, converts (transforms), and joins a list of delimited string to build a complex Array of query-clauses
Either a string or array of strings to include in the clause. Each subsequent filter/coalesce/converter will be applied to each string
An array of TFilters
that will trickle down to the matching index of the coalesce
/converters
An array of TCoalesces
objects that will trickle down to the matching index of the converters
An array of CBConverts
to handle custom transformations matching the index of the corresponding filter
object.
The transformed Array of query-clauses
Concatenates an Array of values, separated by a specified string, and finally, wrapped in specified brackets
An array of values to wrap in brackets
An array (length<=2) specifiying the opening and closing brackets
The string to separate the concatenations
The formatted expression
Not implemented yet.
Creates an CONCAT
expression for use in a SQL
query
The strings to concatenate
The formatted expression
Creates an CONCAT_WS
expression for use in a SQL
query
The string to separate the concatenations
The strings to concatenate
The formatted expression
Allows you to create SocketLinks
in a SQL
query
A column SELECT
statement that formats SocketLink
string within a SQL
query
Creates an LIMIT
clause for use in a SQL
query
The limit value
The formatted clause
Creates an OFFSET
clause for use in a SQL
query
The offset value
The formatted clause
A collection of SQL Utilities