indicate if JSON fields for MariaDB server 10.5.2+ results 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 result-set will not contain some data due to having duplicate identifier (Default: true)
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
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 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
SQL command to execute
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 to cast result types.
Generated using TypeDoc
Indicate if array are included in parenthesis. This option permit compatibility with version < 2.5