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