indicate if JSON fields for MariaDB server 10.5.2+ result in JSON format (or String if disabled)
Force returning BIGINT data as Number in place of BigInt.
Default: false;
disabled bulk command in batch.
indicate to throw an exception if a result-set does not contain some data due to having duplicate identifier (Default: true)
Throw if conversion to Number is not safe.
Default: false;
Whether to retrieve dates as strings or as Date objects.
force returning decimal values as Number in place of String
Default: false;
Force server version check by explicitly using SELECT VERSION(), not relying on server initial handshake information
force returning insertId as Number in place of BigInt
Configure logger
Compatibility option, causes Promise to return an array object,
[rows, metadata] rather than the rows as JSON objects with a meta property.
Default to false.
Allows the use of named placeholders.
Presents result-sets by table to avoid results with colliding fields. See the query() description for more information.
Allows the use of LOAD DATA INFILE statements. Loading data from a file from the client may be a security issue, as a man-in-the-middle proxy server can change the actual file the server loads. Being able to execute a query on the client gives you access to files on the client. (Default: false)
Compatibility option to permit setting multiple value by a JSON object to replace one question mark. key values will replace the question mark with format like key1=val,key2='val2'. Since it doesn't respect the usual prepared statement format that one value is for one question mark, this can lead to incomprehension, even if you badly use to possible injection.
Sends queries one by one without waiting on the results of the previous entry. (Default: true)
Return result-sets as array, rather than a JSON object. This is a faster way to get results
Allows timeout for command execution.
Forces use of the indicated timezone, rather than the current Node.js timezone. Possible values are Z for UTC, local or ±HH:MM format
Allows casting result types.
Permit to defined function calling for LOAD LOCAL command, for extra verification like path restriction.
Generated using TypeDoc
Indicate if an array is included in parentheses. This option permits compatibility with the connector version < 2.5