QueryOptions

Extends DataMappingOptions

Key	Type	Default	Description
autoCommit	boolean	true	Specifies whether to execute the query in auto-commit mode
objectRows	boolean	false	Specifies whether rows are fetched as <FieldName, Value> pair objects or as arrays of values. Deprecated in favor of rowDecoder, which still works
rowDecoder	'array' | 'object' | RowDecoder		Selects how a row's raw wire data is turned into a value: the built-in array/object shapes, or a custom RowDecoder subclass. Wins over objectRows when both are set
typeMap	DataTypeMap	GlobalTypeMap	Data type map instance
cursor	boolean		If true, returns a Cursor instance instead of rows
params	(BindParam | any)[]		Query execution parameters
columnFormat	DataFormat | DataFormat[]	DataFormat.binary	Specifies the transfer format (binary or text) for each column
fetchCount	number	100	Specifies how many rows will be fetched. For a Cursor, this value specifies how many rows will be fetched per batch
rollbackOnError	boolean	true	When off, if a statement in a transaction block generates an error, the error is ignored and the transaction continues. When on (the default), a statement in a transaction block that generates an error aborts the entire transaction
signal	AbortSignal		Aborts the call when the signal fires: the running statement is cancelled on the server and the promise rejects with the signal's own reason, with the database error attached as cause. Cancelling is a request rather than a guarantee — the call settles when the server has actually finished, not the moment abort() is called. AbortSignal.timeout(ms) gives a per-call timeout
asyncErrorHandling	boolean	the connection's own setting	Overrides the connection's own asyncErrorHandling for this call only — see DatabaseConnectionParams.asyncErrorHandling