Query | /mod.ts | sql_builder@v1.9.2

class Query

import { Query } from "https://deno.land/x/sql_builder@v1.9.2/mod.ts";

Properties

private

_fields: string[]

private

_groupBy: string[]

private

_having: string[]

private

_insertValues: any[]

private

_joins: string[]

private

optional

_limit: { start: number; size: number; }

private

_orders: Order[]

private

optional

_table: string

private

optional

_type:

| "select"

| "insert"

| "update"

| "delete"

private

optional

_updateValue: any

private

_where: string[]

private

readonly

deleteSQL

private

readonly

groupSQL

private

readonly

havingSQL

private

readonly

insertSQL

private

readonly

joinSQL

private

readonly

limitSQL

private

readonly

orderSQL

private

readonly

selectSQL

private

readonly

updateSQL

private

readonly

whereSQL

Methods

build(): string

clone()

delete(table?: string)

groupBy(...fields: string[])

having(where: Where | string)

insert(data: Object[] | Object)

join(join: Join | string)

limit(start: number, size: number)

order(...orders: Order[])

select(...fields: string[])

table(name: string)

update(data: Object)

where(where: Where | string)