export default class PostgrestQueryBuilder { url: URLSearchParams; /** * The reserved word order reorders the response rows. * * @param column The column to filter on. * @param value The value to filter with. */ order(column: any, value: any): this; /** * Finds all rows which doesn't satisfy the filter. * * @param column The column to filter on. * @param operator The operator to filter with. * @param value The value to filter with. */ not(column: any, value: any, operator?: string): this; /** * Finds all rows satisfying at least one of the filters. * * @param filters The filters to use, separated by commas. * @param foreignTable The foreign table to use (if `column` is a foreign column). */ or(filters: any, { foreignTable }?: { foreignTable: any; }): this; /** * Finds all rows whose value on the stated `column` exactly matches the * specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ eq(column: any, value: any): this; /** * Finds all rows whose value on the stated `column` doesn't match the * specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ neq(column: any, value: any): this; /** * Finds all rows whose value on the stated `column` is greater than the * specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ gt(column: any, value: any): this; /** * Finds all rows whose value on the stated `column` is greater than or * equal to the specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ gte(column: any, value: any): this; /** * Finds all rows whose value on the stated `column` is less than the * specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ lt(column: any, value: any): this; /** * Finds all rows whose value on the stated `column` is less than or equal * to the specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ lte(column: any, value: any): this; /** * Finds all rows whose value in the stated `column` matches the supplied * `pattern` (case sensitive). * * @param column The column to filter on. * @param pattern The pattern to filter with. */ like(column: any, pattern: any): this; /** * Finds all rows whose value in the stated `column` matches the supplied * `pattern` (case insensitive). * * @param column The column to filter on. * @param pattern The pattern to filter with. */ ilike(column: any, pattern: any): this; /** * A check for exact equality (null, true, false), finds all rows whose * value on the stated `column` exactly match the specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ is(column: any, value: any): this; /** * Finds all rows whose value on the stated `column` is found on the * specified `values`. * * @param column The column to filter on. * @param values The values to filter with. */ in(column: any, values: any): this; /** * Finds all rows whose json, array, or range value on the stated `column` * contains the values specified in `value`. * * @param column The column to filter on. * @param value The value to filter with. */ contains(column: any, value: any): this; /** * Finds all rows whose json, array, or range value on the stated `column` is * contained by the specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ containedBy(column: any, value: any): this; /** * Finds all rows whose range value on the stated `column` is strictly to the * left of the specified `range`. * * @param column The column to filter on. * @param range The range to filter with. */ rangeLt(column: any, range: any): this; /** * Finds all rows whose range value on the stated `column` is strictly to * the right of the specified `range`. * * @param column The column to filter on. * @param range The range to filter with. */ rangeGt(column: any, range: any): this; /** * Finds all rows whose range value on the stated `column` does not extend * to the left of the specified `range`. * * @param column The column to filter on. * @param range The range to filter with. */ rangeGte(column: any, range: any): this; /** * Finds all rows whose range value on the stated `column` does not extend * to the right of the specified `range`. * * @param column The column to filter on. * @param range The range to filter with. */ rangeLte(column: any, range: any): this; /** * Finds all rows whose range value on the stated `column` is adjacent to * the specified `range`. * * @param column The column to filter on. * @param range The range to filter with. */ rangeAdjacent(column: any, range: any): this; /** * Finds all rows whose array or range value on the stated `column` overlaps * (has a value in common) with the specified `value`. * * @param column The column to filter on. * @param value The value to filter with. */ overlaps(column: any, value: any): this; /** * Finds all rows whose text or tsvector value on the stated `column` matches * the tsquery in `query`. * * @param column The column to filter on. * @param query The Postgres tsquery string to filter with. * @param config The text search configuration to use. * @param type The type of tsquery conversion to use on `query`. */ textSearch(column: any, query: any, { config, type }?: { config: any; type?: null | undefined; }): this; /** * Finds all rows whose `column` satisfies the filter. * * @param column The column to filter on. * @param operator The operator to filter with. * @param value The value to filter with. */ filter(column: any, operator: any, value: any): this; /** * Finds all rows whose columns match the specified `query` object. * * @param query The object to filter with, with column names as keys mapped * to their filter values. */ match(query: any): this; limit(size: any): this; offset(offset: any): this; }