Type Alias ReadSqlOptions

Force dialect when it cannot be inferred from the URL.

Maximum rows in the returned DataFrame. When the dialect is known (URL / config, or dialect given with a duck-typed client) and the text is a single SELECT / WITH statement, the limit is pushed into the query (SELECT * FROM (…) AS __columna_q LIMIT n; SQL Server: SET ROWCOUNT n), so the database, the transfer and the driver's buffer are bounded too. Otherwise — several statements, EXEC, unknown dialect, or pushdown: false — the buffered result is sliced after the fact.

Query parameters (positional array or named object, dialect-dependent).

Set to false to keep the SQL untouched and slice the result instead (default: push when possible).