Hi there! Are you looking for the official Deno documentation? Try docs.deno.com for all your Deno learning needs.

CreateViewBuilder

class CreateViewBuilder implements OperationNodeSource, Compilable {

constructor(props: CreateViewBuilderProps);

$call<T>(func: (qb: this) => T): T;

as(query: SelectQueryBuilder<any, any, any> | RawBuilder<any>): CreateViewBuilder;

columns(columns: string[]): CreateViewBuilder;

compile(): CompiledQuery;

execute(): Promise<void>;

ifNotExists(): CreateViewBuilder;

materialized(): CreateViewBuilder;

orReplace(): CreateViewBuilder;

temporary(): CreateViewBuilder;

toOperationNode(): CreateViewNode;

}

§Implements

OperationNodeSource

§Constructors

new CreateViewBuilder(props: CreateViewBuilderProps)

§Methods

$call<T>(func: (qb: this) => T): T

Simply calls the provided function passing this as the only argument. $call returns what the provided function returns.

as(query: SelectQueryBuilder<any, any, any> | RawBuilder<any>): CreateViewBuilder

Sets the select query or a values statement that creates the view.

WARNING! Some dialects don't support parameterized queries in DDL statements and therefore the query or raw sql expression passed here is interpolated into a single string opening an SQL injection vulnerability. DO NOT pass unchecked user input into the query or raw expression passed to this method!

columns(columns: string[]): CreateViewBuilder

compile(): CompiledQuery

execute(): Promise<void>

ifNotExists(): CreateViewBuilder

Only implemented on some dialects like SQLite. On most dialects, use {@link orReplace}.

materialized(): CreateViewBuilder

orReplace(): CreateViewBuilder

temporary(): CreateViewBuilder

Adds the "temporary" modifier.

Use this to create a temporary view.

toOperationNode(): CreateViewNode