'SQL' Query Builder


[Up] [Top]

Documentation for package ‘sqlq’ version 1.0.1

Help Pages

sqlq-package sqlq: 'SQL' Query Builder
apply_case Put string in right case according to global option.
Expr Expression abstact class.
ExprBetween This class represents an SQL BETWEEN expression.
ExprBinOp This class represents an SQL binary operator.
ExprCommOp This class represents an SQL logical operator.
ExprComp Composed Expression class.
ExprField This class represents an SQL field.
ExprFieldDef Table field definition.
ExprIsNotNull This class represents the IS NOT NULL test.
ExprIsNull This class represents the IS NULL test.
ExprList This class represents an SQL list.
ExprListFields This class represents a list of fields.
ExprListValues This class represents a list of values.
ExprUnaryOp This class represents an SQL unary operator.
ExprValue This class represents an SQL value.
make_between Create a BETWEEN expression.
make_create_table Create an SQL CREATE TABLE query.
make_delete Create an SQL DELETE FROM query.
make_fields Create a list of table fields.
make_insert Create an SQL INSERT INTO query.
make_join Create a SQL JOIN statement.
make_row Create a list of SQL values.
make_rows Create a list of rows of values
make_select Create an SQL SELECT query.
make_select_all Create an SQL SELECT query for all fields.
make_set Create an SQL SET statement.
make_update Create an SQL UPDATE query.
make_values Create a list of SQL values.
make_where Create a WHERE clause.
Query This class handles an SQL Query.
QueryCreate Create query.
QueryDelete Delete query.
QueryInsert Insert query.
QuerySelect Class for the SELECT query.
QueryUpdate Update Query.
quote_ids Quote identifiers (e.g.: table names or field names) for SQL queries.
quote_values Quote character values for SQL queries.
sqlq sqlq: 'SQL' Query Builder
Statement Abstract class that represents an SQL statement.
StmtCreate CREATE TABLE statement.
StmtDelete DELETE FROM statement.
StmtFrom SQL From statement.
StmtInsert INSERT INTO statement.
StmtJoin SQL JOIN statement.
StmtLimit LIMIT statement.
StmtSelect Abstract SELECT statement.
StmtSelectAll SELECT * statement.
StmtSelectFields SELECT fields statement.
StmtSet SET statement.
StmtUpdate UPDATE statement.
StmtValues VALUES statement.
StmtWhere SQL WHERE statement.
Token Abstract Token class.
TokenEmpty Empty token class.
TokenIdentifier TokenIdentifier class.
TokenKeyword TokenKeyword class.
TokenSymbol TokenSymbol class.
TokenValue Token value class.