static/jsvm/interfaces/dbx.QueryBuilder.html
QueryBuilder builds different clauses for a SELECT SQL statement.
buildFrombuildGroupBybuildHavingbuildJoinbuildOrderByAndLimitbuildSelectbuildUnionbuildWherecombineUnion
BuildFrom generates a FROM clause from the given tables.
BuildGroupBy generates a GROUP BY clause from the given group-by columns.
BuildHaving generates a HAVING clause from the given expression.
BuildJoin generates a JOIN clause from the given join information.
BuildOrderByAndLimit generates the ORDER BY and LIMIT clauses.
BuildSelect generates a SELECT clause from the given selected column names.
BuildUnion generates a UNION clause from the given union information.
BuildWhere generates a WHERE clause from the given expression.
CombineUnion combines the nonempty unionClause with the provided sql string.
The unionClause is expected to be the result of BuildUnion. If the unionClause is an empty string it returns the sql argument unmodified.
This method exists as a workaround to minimize breaking changes and to allow different SQL builders to specify for example whether they support parenthesis around the UNION SQL queries (SQLite for example will throw a SyntaxError if the UNION parts are wrapped in parenthesis).
OSLightDark
Generated using TypeDoc