CreateViewBuilder
class CreateViewBuilder implements OperationNodeSource, Compilable {}
constructor(props: CreateViewBuilderProps);
$call<T>(func: (qb: this) => T): T;
compile(): CompiledQuery;
execute(): Promise<void>;
ifNotExists(): CreateViewBuilder;
materialized(): CreateViewBuilder;
orReplace(): CreateViewBuilder;
temporary(): CreateViewBuilder;
toOperationNode(): CreateViewNode;
§Constructors
§
new CreateViewBuilder(props: CreateViewBuilderProps)
[src]§Methods
§
$call<T>(func: (qb: this) => T): T
[src]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
[src]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 {@link 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
[src]§
compile(): CompiledQuery
[src]§
ifNotExists(): CreateViewBuilder
[src]Only implemented on some dialects like SQLite. On most dialects, use {@link orReplace}.
§
materialized(): CreateViewBuilder
[src]§
orReplace(): CreateViewBuilder
[src]§
temporary(): CreateViewBuilder
[src]Adds the "temporary" modifier.
Use this to create a temporary view.
§
toOperationNode(): CreateViewNode
[src]