src Void close()

Close the statement.

src Obj execute([Str:Obj]? params := null)

Execute a SQL statement and if applicable return a result:

• If the statement is a query or procedure which produces a result set, then return Row[]
• If the statement is an insert and auto-generated keys are supported by the connector then return Int[] or Str[] of keys generated
• Return an Int with the update count

src Int? limit

Maximum number of rows returned when this statement is executed. If limit is exceeded rows are silently dropped. A value of null indicates no limit.

src This prepare()

Prepare this statement by compiling for efficient execution. Return this.

src Row[] query([Str:Obj]? params := null)

Execute the statement and return the resulting List of Rows. The Cols are available from List.of.fields or on type.fields of each row instance.

src Void queryEach([Str:Obj]? params, |Row| eachFunc)

Execute the statement. For each row in the result, invoke the specified function eachFunc.

src Obj? queryEachWhile([Str:Obj]? params, |Row->Obj?| eachFunc)

Execute the statement. For each row in the result, invoke the specified function eachFunc. If the function returns non-null, then break the iteration and return the resulting object. Return null if the function returns null for every item.

src const Str sql

The SQL text used to create this statement.