CipherStash Docs
StackLatestSupabaseInterfaces

EncryptedQueryBuilder

API reference for EncryptedQueryBuilder

@cipherstash/stack


Interface: EncryptedQueryBuilder<T>

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:232

Extends

Type Parameters

T

T extends Record<string, unknown> = Record<string, unknown>

Methods

select()

select(columns, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:235

Parameters

columns

string

options?

boolean

count?

"exact" | "planned" | "estimated"

Returns

EncryptedQueryBuilder<T>


insert()

insert(data, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:239

Parameters

data

Partial<T> | Partial<T>[]

options?
count?

"exact" | "planned" | "estimated"

defaultToNull?

boolean

onConflict?

string

Returns

EncryptedQueryBuilder<T>


update()

update(data, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:247

Parameters

data

Partial<T>

options?
count?

"exact" | "planned" | "estimated"

Returns

EncryptedQueryBuilder<T>


upsert()

upsert(data, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:251

Parameters

data

Partial<T> | Partial<T>[]

options?
count?

"exact" | "planned" | "estimated"

onConflict?

string

ignoreDuplicates?

boolean

defaultToNull?

boolean

Returns

EncryptedQueryBuilder<T>


delete()

delete(options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:260

Parameters

options?
count?

"exact" | "planned" | "estimated"

Returns

EncryptedQueryBuilder<T>


eq()

eq&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:263

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

EncryptedQueryBuilder<T>


neq()

neq&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:264

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

EncryptedQueryBuilder<T>


gt()

gt&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:268

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

EncryptedQueryBuilder<T>


gte()

gte&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:269

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

EncryptedQueryBuilder<T>


lt()

lt&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:273

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

EncryptedQueryBuilder<T>


lte()

lte&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:274

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

EncryptedQueryBuilder<T>


like()

like&lt;K&gt;(column, pattern): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:278

Type Parameters

K

K extends string

Parameters

column

K

pattern

string

Returns

EncryptedQueryBuilder<T>


ilike()

ilike&lt;K&gt;(column, pattern): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:282

Type Parameters

K

K extends string

Parameters

column

K

pattern

string

Returns

EncryptedQueryBuilder<T>


is()

is&lt;K&gt;(column, value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:286

Type Parameters

K

K extends string

Parameters

column

K

value

boolean | null

Returns

EncryptedQueryBuilder<T>


in()

in&lt;K&gt;(column, values): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:290

Type Parameters

K

K extends string

Parameters

column

K

values

T[K][]

Returns

EncryptedQueryBuilder<T>


filter()

filter&lt;K&gt;(
   column, 
   operator, 
   value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:294

Type Parameters

K

K extends string

Parameters

column

K

operator

string

value

T[K]

Returns

EncryptedQueryBuilder<T>


not()

not&lt;K&gt;(
   column, 
   operator, 
   value): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:299

Type Parameters

K

K extends string

Parameters

column

K

operator

string

value

T[K]

Returns

EncryptedQueryBuilder<T>


or()

Call Signature

or(filters, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:304

Parameters
filters

string

options?
referencedTable?

string

foreignTable?

string

Returns

EncryptedQueryBuilder<T>

Call Signature

or(conditions, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:308

Parameters
conditions

PendingOrCondition[]

options?
referencedTable?

string

foreignTable?

string

Returns

EncryptedQueryBuilder<T>


match()

match(query): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:312

Parameters

query

Partial<T>

Returns

EncryptedQueryBuilder<T>


order()

order&lt;K&gt;(column, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:313

Type Parameters

K

K extends string

Parameters

column

K

options?
ascending?

boolean

nullsFirst?

boolean

referencedTable?

string

foreignTable?

string

Returns

EncryptedQueryBuilder<T>


limit()

limit(count, options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:322

Parameters

count

number

options?
referencedTable?

string

foreignTable?

string

Returns

EncryptedQueryBuilder<T>


range()

range(
   from, 
   to, 
   options?): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:326

Parameters

from

number

to

number

options?
referencedTable?

string

foreignTable?

string

Returns

EncryptedQueryBuilder<T>


single()

single(): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:331

Returns

EncryptedQueryBuilder<T>


maybeSingle()

maybeSingle(): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:332

Returns

EncryptedQueryBuilder<T>


csv()

csv(): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:333

Returns

EncryptedQueryBuilder<T>


abortSignal()

abortSignal(signal): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:334

Parameters

signal

AbortSignal

Returns

EncryptedQueryBuilder<T>


throwOnError()

throwOnError(): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:335

Returns

EncryptedQueryBuilder<T>


returns()

returns&lt;U&gt;(): EncryptedQueryBuilder&lt;U&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:336

Type Parameters

U

U extends Record<string, unknown>

Returns

EncryptedQueryBuilder<U>


withLockContext()

withLockContext(lockContext): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:337

Parameters

lockContext

LockContext

Returns

EncryptedQueryBuilder<T>


audit()

audit(config): EncryptedQueryBuilder&lt;T&gt;;

Defined in: .tmp-stack/packages/stack/src/supabase/types.ts:338

Parameters

config

AuditConfig

Returns

EncryptedQueryBuilder<T>


then()

then&lt;TResult1, TResult2&gt;(onfulfilled?, onrejected?): PromiseLike&lt;TResult1 | TResult2&gt;;

Defined in: node_modules/.pnpm/typescript@5.9.3/node_modules/typescript/lib/lib.es5.d.ts:1544

Attaches callbacks for the resolution and/or rejection of the Promise.

Type Parameters

TResult1

TResult1 = EncryptedSupabaseResponse<T[]>

TResult2

TResult2 = never

Parameters

onfulfilled?

The callback to execute when the Promise is resolved.

(value) => TResult1 | PromiseLike<TResult1> | null

onrejected?

The callback to execute when the Promise is rejected.

(reason) => TResult2 | PromiseLike<TResult2> | null

Returns

PromiseLike<TResult1 | TResult2>

A Promise for the completion of which ever callback is executed.

Inherited from

PromiseLike.then

On this page

Interface: EncryptedQueryBuilder<T>ExtendsType ParametersTMethodsselect()Parameterscolumnsoptions?head?count?Returnsinsert()Parametersdataoptions?count?defaultToNull?onConflict?Returnsupdate()Parametersdataoptions?count?Returnsupsert()Parametersdataoptions?count?onConflict?ignoreDuplicates?defaultToNull?Returnsdelete()Parametersoptions?count?Returnseq()Type ParametersKParameterscolumnvalueReturnsneq()Type ParametersKParameterscolumnvalueReturnsgt()Type ParametersKParameterscolumnvalueReturnsgte()Type ParametersKParameterscolumnvalueReturnslt()Type ParametersKParameterscolumnvalueReturnslte()Type ParametersKParameterscolumnvalueReturnslike()Type ParametersKParameterscolumnpatternReturnsilike()Type ParametersKParameterscolumnpatternReturnsis()Type ParametersKParameterscolumnvalueReturnsin()Type ParametersKParameterscolumnvaluesReturnsfilter()Type ParametersKParameterscolumnoperatorvalueReturnsnot()Type ParametersKParameterscolumnoperatorvalueReturnsor()Call SignatureParametersfiltersoptions?referencedTable?foreignTable?ReturnsCall SignatureParametersconditionsoptions?referencedTable?foreignTable?Returnsmatch()ParametersqueryReturnsorder()Type ParametersKParameterscolumnoptions?ascending?nullsFirst?referencedTable?foreignTable?Returnslimit()Parameterscountoptions?referencedTable?foreignTable?Returnsrange()Parametersfromtooptions?referencedTable?foreignTable?Returnssingle()ReturnsmaybeSingle()Returnscsv()ReturnsabortSignal()ParameterssignalReturnsthrowOnError()Returnsreturns()Type ParametersUReturnswithLockContext()ParameterslockContextReturnsaudit()ParametersconfigReturnsthen()Type ParametersTResult1TResult2Parametersonfulfilled?onrejected?ReturnsInherited from