class default
implements IQuery
import { default } from "https://dotland.deno.dev/x/justaos_orm@v10.1.0/src/core/query-builder/DQL/SelectQuery.ts";
Methods
andWhere(): SelectQuery
This method is used to set the AND where clause. (same as where)
buildCountQuery(): string
buildQuery(): string
columns(columnNameOrObjectOrArray?: string | string[] | { [key: string]: boolean; }, ...otherColumns: string[]): SelectQuery
This method is used to set the columns for the select query.
from(tableOrTablesArray: string | string[], ...otherTableNames: string[]): SelectQuery
This method is used to set the table or tables for the select query.
groupBy(columnNameOrObjectOrArray?: string | string[] | { [key: string]: boolean; }, ...otherColumns: string[]): SelectQuery
This method is used to set the group by clause for the select query.
orderBy(columnNameOrOrderList?: string | TOrderBy[], direction?: TOrderByDirection): SelectQuery
This method is used to set the order by clause for the select query.
orWhere(): SelectQuery
This method is used to set the or where clause for the select query.
where(): SelectQuery
This method is used to set the where clause for the select query.