import { default } from "https://dotland.deno.dev/x/justaos_orm@v10.0.0/src/query/Query.ts";
Constructors
new
default(pool: DatabaseConnectionPool)Methods
addColumn(column: __TColumnDefinitionNative): Query
alter(nameWithSchema: string): Query
andWhere(): Query
This method is used to set the AND where clause. (same as where)
columns(...args: any[]): Query
create(nameWithSchema: string): Query
cursor(): Promise<{ cursor: any; reserve: DatabaseClient; }>
delete(): Query
execute(sqlString?: string): Promise<any>
from(name: string): Query
getCountSQLQuery(): string
getInstance(): Query
getSQLQuery(): string
getType(): string | undefined
groupBy(columnName: string): Query
inherits(nameWithSchema: string | undefined): Query
insert(): Query
into(nameWithSchema: string): Query
limit(limit: number): Query
offset(offset: number): Query
orderBy(columnNameOrOrderList?: string | TOrderBy[], direction?: TOrderByDirection): Query
orWhere(): Query
This method is used to set the or where clause for the query.
returning(...args: any[]): Query
select(columnNameOrObjectOrArray?: string | string[] | { [key: string]: boolean; }, ...otherColumns: string[]): Query
This method is used to set the columns for the select query.
set(columnOrRecord: string | { [key: string]: any; }, value?: any): Query
setQuery(query: QueryType)
update(): Query
values(rows: any[]): Query
where(): Query
This method is used to set the where clause for the query.