Index

Symbols

**_kwargs (sqlspec.adapters.aiosqlite.AiosqliteConfig.provide_session parameter) **kwargs (sqlspec.adapters.adbc.AdbcConfig.provide_connection parameter) (sqlspec.adapters.adbc.AdbcConfig.provide_session parameter) (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig.provide_connection parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig.provide_connection parameter), [1] (sqlspec.adapters.asyncpg.AsyncpgConfig.provide_session parameter), [1] (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.duckdb.DuckDBConfig.provide_connection parameter) (sqlspec.adapters.duckdb.DuckDBConfig.provide_session parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.base.SQLSpec.provide_connection parameter) (sqlspec.base.SQLSpec.provide_session parameter) (sqlspec.builder.Delete parameter) (sqlspec.builder.Insert parameter) (sqlspec.builder.Insert.on_duplicate_key_update parameter) (sqlspec.builder.Merge parameter) (sqlspec.builder.Select parameter) (sqlspec.builder.Update parameter) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL.copy parameter) (sqlspec.core.statement.StatementConfig.replace parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_with_total parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1]

**parameters (sqlspec.builder.SQLFactory.raw parameter) *_args (sqlspec.adapters.aiosqlite.AiosqliteConfig.provide_session parameter) *args (sqlspec.adapters.adbc.AdbcConfig.provide_connection parameter) (sqlspec.adapters.adbc.AdbcConfig.provide_session parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig.provide_connection parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig.provide_connection parameter), [1] (sqlspec.adapters.asyncpg.AsyncpgConfig.provide_session parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig.provide_connection parameter) (sqlspec.adapters.duckdb.DuckDBConfig.provide_session parameter) (sqlspec.base.SQLSpec.provide_connection parameter) (sqlspec.base.SQLSpec.provide_session parameter) (sqlspec.builder.SQLFactory.decode parameter) (sqlspec.exceptions.StackExecutionError parameter) *column_sets (sqlspec.builder.SQLFactory.grouping_sets parameter) *columns (sqlspec.builder.Insert.on_conflict parameter) (sqlspec.builder.Insert.on_conflict_do_nothing parameter) (sqlspec.builder.Select parameter) (sqlspec.builder.SQLFactory.cube parameter) (sqlspec.builder.SQLFactory.rollup parameter) *expressions (sqlspec.builder.SQLFactory.coalesce parameter) (sqlspec.builder.SQLFactory.concat parameter) *parameters (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.core.statement.SQL parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_with_total parameter) *paths (sqlspec.base.SQLSpec.load_sql_files parameter) (sqlspec.loader.SQLFileLoader.load_sql parameter)

_

__aenter__() (sqlspec.base.SQLSpec method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) __aexit__() (sqlspec.base.SQLSpec method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) __call__() (sqlspec.builder.SQLFactory method) __contains__() (sqlspec.core.cache.UnifiedCache method) __eq__() (sqlspec.core.cache.CacheKey method) (sqlspec.core.compiler.CompiledSQL method) (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) (sqlspec.driver._common.VersionInfo method) __ge__() (sqlspec.driver._common.VersionInfo method) __getattr__() (sqlspec.builder.SQLFactory method) __getitem__() (sqlspec.core.result.SQLResult method) __gt__() (sqlspec.driver._common.VersionInfo method) __hash__() (sqlspec.core.cache.CacheKey method) (sqlspec.core.compiler.CompiledSQL method) (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) (sqlspec.driver._common.VersionInfo method) __init__() (sqlspec.adapters.adbc.AdbcConfig method) (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.adapters.duckdb.DuckDBConfig method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteConfig method) (sqlspec.adapters.sqlite.SqliteDriver method) (sqlspec.base.SQLSpec method) (sqlspec.builder.Delete method) (sqlspec.builder.Insert method) (sqlspec.builder.Merge method) (sqlspec.builder.Select method) (sqlspec.builder.SQLFactory method) (sqlspec.builder.Update method) (sqlspec.core.cache.CacheConfig method) (sqlspec.core.cache.CacheKey method) (sqlspec.core.cache.CacheStats method) (sqlspec.core.cache.MultiLevelCache method) (sqlspec.core.cache.UnifiedCache method) (sqlspec.core.compiler.CompiledSQL method) (sqlspec.core.compiler.SQLProcessor method) (sqlspec.core.filters.LimitOffsetFilter method) (sqlspec.core.filters.OrderByFilter method) (sqlspec.core.filters.SearchFilter method) (sqlspec.core.parameters.ParameterConverter method) (sqlspec.core.parameters.ParameterProcessor method) (sqlspec.core.parameters.ParameterStyleConfig method) (sqlspec.core.parameters.ParameterValidator method) (sqlspec.core.result.SQLResult method) (sqlspec.core.result.StackResult method) (sqlspec.core.stack.StackOperation method) (sqlspec.core.stack.StatementStack method) (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) (sqlspec.driver._common.CommonDriverAttributesMixin method) (sqlspec.driver._common.StackExecutionObserver method) (sqlspec.driver._common.VersionInfo method) (sqlspec.exceptions.StackExecutionError method) (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) (sqlspec.extensions.adk.SQLSpecSessionService method) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] (sqlspec.extensions.litestar.BaseSQLSpecStore method) (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware method) (sqlspec.extensions.starlette.SQLSpecManualMiddleware method) (sqlspec.extensions.starlette.SQLSpecPlugin method) (sqlspec.loader.SQLFileLoader method)

__iter__() (sqlspec.core.result.SQLResult method) __le__() (sqlspec.driver._common.VersionInfo method) __len__() (sqlspec.core.cache.UnifiedCache method) (sqlspec.core.result.SQLResult method) __lt__() (sqlspec.driver._common.VersionInfo method) __new__() (sqlspec.core.parameters.ParameterStyle method) __repr__() (sqlspec.core.cache.CacheKey method) (sqlspec.core.cache.CacheStats method) (sqlspec.core.compiler.CompiledSQL method) (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) (sqlspec.driver._common.VersionInfo method) __str__() (sqlspec.driver._common.VersionInfo method)

A

actions (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] AdbcConfig (class in sqlspec.adapters.adbc) AdbcDriver (class in sqlspec.adapters.adbc) add_config() (sqlspec.base.SQLSpec method) add_named_parameter() (sqlspec.core.statement.SQL method) add_named_sql() (sqlspec.base.SQLSpec method) (sqlspec.loader.SQLFileLoader method) add_statement_result() (sqlspec.core.result.SQLResult method) after_timestamp (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.get_events parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.get_events parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.get_events parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.get_events parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.get_events parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.get_events parameter), [1] AiosqlAsyncAdapter (class in sqlspec.extensions.aiosql), [1] AiosqliteConfig (class in sqlspec.adapters.aiosqlite) AiosqliteDriver (class in sqlspec.adapters.aiosqlite) AiosqliteStore (class in sqlspec.adapters.aiosqlite.litestar) AiosqlSyncAdapter (class in sqlspec.extensions.aiosql), [1] alias (sqlspec.builder.Update.join parameter) all() (sqlspec.core.result.SQLResult method) all_ (sqlspec.builder.SQLFactory property) allow_mixed_parameter_styles (sqlspec.core.parameters.ParameterStyleConfig attribute) alter_table() (sqlspec.builder.SQLFactory method) any() (sqlspec.builder.SQLFactory static method) any_ (sqlspec.builder.SQLFactory property) app (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware parameter) (sqlspec.extensions.starlette.SQLSpecManualMiddleware parameter) (sqlspec.extensions.starlette.SQLSpecPlugin parameter) (sqlspec.extensions.starlette.SQLSpecPlugin.init_app parameter) (sqlspec.extensions.starlette.SQLSpecPlugin.lifespan parameter) app_config (sqlspec.extensions.litestar.SQLSpecPlugin.on_app_init parameter), [1] app_name (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.create_session parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.list_sessions parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.create_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.list_sessions parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.create_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.list_sessions parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.list_sessions parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.list_sessions parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.list_sessions parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.list_sessions parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.list_sessions parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.create_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.list_sessions parameter) (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk._types.SessionRecord attribute) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.list_sessions parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.list_sessions parameter), [1] (sqlspec.extensions.adk.converters.event_to_record parameter) (sqlspec.extensions.adk.SQLSpecSessionService.create_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.delete_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.get_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.list_sessions parameter), [1]

append_event() (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.SQLSpecSessionService method) append_to_statement() (sqlspec.core.filters.LimitOffsetFilter method) (sqlspec.core.filters.OrderByFilter method) (sqlspec.core.filters.SearchFilter method) (sqlspec.core.filters.StatementFilter method) arguments (sqlspec.core.stack.StackOperation attribute) arrow_schema (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) as_script() (sqlspec.core.statement.SQL method) ast_transformer (sqlspec.core.parameters.ParameterStyleConfig attribute) AsyncDriverAdapterBase (class in sqlspec.driver._async) AsyncpgConfig (class in sqlspec.adapters.asyncpg) AsyncpgDriver (class in sqlspec.adapters.asyncpg) AsyncpgPoolConfig (class in sqlspec.adapters.asyncpg) AsyncpgStore (class in sqlspec.adapters.asyncpg.litestar) attach_observability() (sqlspec.driver._common.CommonDriverAttributesMixin method) author (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] avg() (sqlspec.builder.SQLFactory static method)

B

BaseAsyncADKStore (class in sqlspec.extensions.adk) BaseSQLSpecStore (class in sqlspec.extensions.litestar) BaseSyncADKStore (class in sqlspec.extensions.adk) BaseTypeConverter (class in sqlspec.core.type_conversion) batch_size (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) begin() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method)

bind_key (sqlspec.adapters.adbc.AdbcConfig parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) branch (sqlspec.extensions.adk._types.EventRecord attribute) build() (sqlspec.builder.Delete method) (sqlspec.builder.Merge method) (sqlspec.builder.Select method) (sqlspec.builder.Update method) build_statement_result() (sqlspec.driver._common.CommonDriverAttributesMixin method) bulk_insert() (sqlspec.builder.SQLFactory static method)

C

cache_stats (sqlspec.core.compiler.SQLProcessor property) CacheConfig (class in sqlspec.core.cache) CacheKey (class in sqlspec.core.cache) CacheStats (class in sqlspec.core.cache) call_next (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware.dispatch parameter) (sqlspec.extensions.starlette.SQLSpecManualMiddleware.dispatch parameter) case() (sqlspec.builder.SQLFactory static method) case_ (sqlspec.builder.SQLFactory property) cast() (sqlspec.builder.SQLFactory static method) clear() (sqlspec.core.cache.MultiLevelCache method) (sqlspec.core.cache.UnifiedCache method) clear_cache() (sqlspec.core.compiler.SQLProcessor method) (sqlspec.loader.SQLFileLoader method) clear_file_cache() (sqlspec.loader.SQLFileLoader method) clear_sql_cache() (sqlspec.base.SQLSpec method) cli (sqlspec.extensions.litestar.SQLSpecPlugin.on_cli_init parameter), [1] close_all_pools() (sqlspec.base.SQLSpec method) close_pool() (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) (sqlspec.base.SQLSpec method) coalesce() (sqlspec.builder.SQLFactory static method) column (sqlspec.builder.SQLFactory.avg parameter) (sqlspec.builder.SQLFactory.cast parameter) (sqlspec.builder.SQLFactory.count parameter) (sqlspec.builder.SQLFactory.count_distinct parameter) (sqlspec.builder.SQLFactory.decode parameter) (sqlspec.builder.SQLFactory.length parameter) (sqlspec.builder.SQLFactory.lower parameter) (sqlspec.builder.SQLFactory.max parameter) (sqlspec.builder.SQLFactory.min parameter) (sqlspec.builder.SQLFactory.nvl parameter) (sqlspec.builder.SQLFactory.nvl2 parameter) (sqlspec.builder.SQLFactory.round parameter) (sqlspec.builder.SQLFactory.sum parameter) (sqlspec.builder.SQLFactory.upper parameter) column() (sqlspec.builder.SQLFactory method) column_count (sqlspec.builder.SQLFactory.bulk_insert parameter) column_names (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) command_timeout (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) comment_on() (sqlspec.builder.SQLFactory method) commit() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) CommonDriverAttributesMixin (class in sqlspec.driver._common) compile() (sqlspec.core.compiler.SQLProcessor method) (sqlspec.core.statement.SQL method) compiled_cache_enabled (sqlspec.core.cache.CacheConfig parameter) compiled_sql (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) CompiledSQL (class in sqlspec.core.compiler) concat() (sqlspec.builder.SQLFactory static method) condition (sqlspec.core.statement.SQL.where parameter) config (sqlspec.adapters.adbc.adk.AdbcADKStore parameter), [1] (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore parameter), [1] (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore parameter), [1] (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore parameter), [1] (sqlspec.adapters.asyncpg.litestar.AsyncpgStore parameter), [1] (sqlspec.adapters.duckdb.adk.DuckdbADKStore parameter), [1] (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore parameter), [1] (sqlspec.adapters.oracledb.adk.OracleSyncADKStore parameter), [1] (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore parameter), [1] (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore parameter), [1] (sqlspec.adapters.sqlite.adk.SqliteADKStore parameter), [1] (sqlspec.base.SQLSpec.add_config parameter) (sqlspec.base.SQLSpec.update_cache_config parameter) (sqlspec.core.compiler.SQLProcessor parameter) (sqlspec.core.parameters.ParameterProcessor.get_sqlglot_compatible_sql parameter) (sqlspec.extensions.adk.BaseAsyncADKStore parameter), [1], [2], [3] (sqlspec.extensions.adk.BaseAsyncADKStore property) (sqlspec.extensions.adk.BaseSyncADKStore parameter), [1], [2], [3] (sqlspec.extensions.adk.BaseSyncADKStore property) (sqlspec.extensions.adk.SQLSpecSessionService.get_session parameter), [1] (sqlspec.extensions.litestar.BaseSQLSpecStore parameter), [1] (sqlspec.extensions.litestar.BaseSQLSpecStore property) (sqlspec.extensions.litestar.SQLSpecPlugin property), [1]

config_state (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware parameter) (sqlspec.extensions.starlette.SQLSpecManualMiddleware parameter) configs (sqlspec.base.SQLSpec property) configure_cache() (sqlspec.base.SQLSpec static method) conn (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_value parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_value parameter), [1] connect_timeout (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) connection (sqlspec.adapters.adbc.AdbcDriver parameter) (sqlspec.adapters.adbc.AdbcDriver.with_cursor parameter) (sqlspec.adapters.aiosqlite.AiosqliteDriver parameter) (sqlspec.adapters.asyncpg.AsyncpgDriver parameter) (sqlspec.adapters.duckdb.DuckDBDriver parameter) (sqlspec.adapters.duckdb.DuckDBDriver.with_cursor parameter) (sqlspec.adapters.sqlite.SqliteDriver parameter) (sqlspec.adapters.sqlite.SqliteDriver.with_cursor parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.dispatch_statement_execution parameter) (sqlspec.driver._common.CommonDriverAttributesMixin attribute) (sqlspec.driver._common.CommonDriverAttributesMixin parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.dispatch_statement_execution parameter) connection_class (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) connection_config (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.adbc.AdbcConfig parameter) connection_type (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) content (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] continue_on_error (sqlspec.driver._common.StackExecutionObserver attribute) convert_if_detected() (sqlspec.core.type_conversion.BaseTypeConverter method) convert_placeholder_style() (sqlspec.core.parameters.ParameterConverter method) convert_value() (sqlspec.core.type_conversion.BaseTypeConverter method) copy() (sqlspec.builder.SQLFactory method) (sqlspec.core.statement.SQL method) copy_from() (sqlspec.builder.SQLFactory method) copy_to() (sqlspec.builder.SQLFactory method) count() (sqlspec.builder.SQLFactory method) count_distinct() (sqlspec.builder.SQLFactory method) create_connection() (sqlspec.adapters.adbc.AdbcConfig method) (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) (sqlspec.adapters.duckdb.DuckDBConfig method) (sqlspec.adapters.sqlite.SqliteConfig method) create_event() (sqlspec.extensions.adk.BaseSyncADKStore method) create_execution_result() (sqlspec.driver._common.CommonDriverAttributesMixin method) create_index() (sqlspec.builder.SQLFactory method) create_materialized_view() (sqlspec.builder.SQLFactory method) create_schema() (sqlspec.builder.SQLFactory method) create_session() (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) (sqlspec.extensions.adk.SQLSpecSessionService method) create_table() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.builder.SQLFactory method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) create_table_as_select() (sqlspec.builder.SQLFactory method) create_tables() (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) create_time (sqlspec.extensions.adk._types.SessionRecord attribute) create_view() (sqlspec.builder.SQLFactory method) cross_join_ (sqlspec.builder.SQLFactory property) cross_lateral_join_ (sqlspec.builder.SQLFactory property) cube() (sqlspec.builder.SQLFactory static method) cursor_result (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) (sqlspec.driver._common.ScriptExecutionResult attribute) custom_metadata (sqlspec.extensions.adk._types.EventRecord attribute)

D

data (sqlspec.builder.Insert.values_from_dict parameter) (sqlspec.builder.Insert.values_from_dicts parameter) (sqlspec.core.result.SQLResult parameter) data_dictionary (sqlspec.adapters.adbc.AdbcDriver property) (sqlspec.adapters.aiosqlite.AiosqliteDriver property) (sqlspec.adapters.asyncpg.AsyncpgDriver property) (sqlspec.adapters.duckdb.DuckDBDriver property) (sqlspec.adapters.psycopg.PsycopgAsyncDriver property) (sqlspec.adapters.psycopg.PsycopgSyncDriver property) (sqlspec.adapters.sqlite.SqliteDriver property) (sqlspec.driver._async.AsyncDriverAdapterBase property) (sqlspec.driver._sync.SyncDriverAdapterBase property) data_row_count (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) data_type (sqlspec.builder.SQLFactory.cast parameter) database (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) DataDictionaryMixin (class in sqlspec.driver._common) decimals (sqlspec.builder.SQLFactory.round parameter) decode() (sqlspec.builder.SQLFactory static method) default (sqlspec.core.result.SQLResult.get_metadata parameter) DEFAULT_CACHE_SIZE (sqlspec.core.parameters.ParameterProcessor attribute) default_execution_parameter_style (sqlspec.core.parameters.ParameterStyleConfig attribute) default_parameter_style (sqlspec.core.parameters.ParameterStyleConfig attribute) Delete (class in sqlspec.builder) delete() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.builder.SQLFactory method) (sqlspec.core.cache.MultiLevelCache method) (sqlspec.core.cache.UnifiedCache method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) delete_all() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) delete_expired() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) delete_session() (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) (sqlspec.extensions.adk.SQLSpecSessionService method) dense_rank() (sqlspec.builder.SQLFactory method) dense_rank_ (sqlspec.builder.SQLFactory property) describe_stack_statement() (in module sqlspec.driver._common) detail (sqlspec.exceptions.StackExecutionError parameter) detect_sql_type() (sqlspec.builder.SQLFactory class method) detect_type() (sqlspec.core.type_conversion.BaseTypeConverter method) detect_version_with_queries() (sqlspec.driver._common.DataDictionaryMixin method) detected_type (sqlspec.core.type_conversion.BaseTypeConverter.convert_value parameter) dialect (sqlspec.adapters.adbc.AdbcDriver attribute) (sqlspec.adapters.aiosqlite.AiosqliteDriver attribute) (sqlspec.adapters.asyncpg.AsyncpgDriver attribute) (sqlspec.adapters.duckdb.DuckDBDriver attribute) (sqlspec.adapters.psycopg.PsycopgAsyncDriver attribute) (sqlspec.adapters.psycopg.PsycopgSyncDriver attribute) (sqlspec.adapters.sqlite.SqliteDriver attribute) (sqlspec.base.SQLSpec.add_named_sql parameter) (sqlspec.builder.Delete.build parameter) (sqlspec.builder.Merge.build parameter) (sqlspec.builder.Select.build parameter) (sqlspec.builder.Select.with_hint parameter) (sqlspec.builder.SQLFactory parameter) (sqlspec.builder.SQLFactory.__call__ parameter) (sqlspec.builder.SQLFactory.alter_table parameter) (sqlspec.builder.SQLFactory.comment_on parameter) (sqlspec.builder.SQLFactory.create_index parameter) (sqlspec.builder.SQLFactory.create_materialized_view parameter) (sqlspec.builder.SQLFactory.create_schema parameter) (sqlspec.builder.SQLFactory.create_table parameter) (sqlspec.builder.SQLFactory.create_table_as_select parameter) (sqlspec.builder.SQLFactory.create_view parameter) (sqlspec.builder.SQLFactory.drop_index parameter) (sqlspec.builder.SQLFactory.drop_schema parameter) (sqlspec.builder.SQLFactory.drop_table parameter) (sqlspec.builder.SQLFactory.drop_view parameter) (sqlspec.builder.SQLFactory.rename_table parameter) (sqlspec.builder.SQLFactory.upsert parameter) (sqlspec.builder.Update.build parameter) (sqlspec.core.cache.MultiLevelCache.delete parameter) (sqlspec.core.cache.MultiLevelCache.get parameter) (sqlspec.core.cache.MultiLevelCache.put parameter) (sqlspec.core.parameters.ParameterProcessor.get_sqlglot_compatible_sql parameter) (sqlspec.core.statement.SQL property) (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) (sqlspec.loader.SQLFileLoader.add_named_sql parameter)

direct_tls (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) dispatch() (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware method) (sqlspec.extensions.starlette.SQLSpecManualMiddleware method) dispatch_statement_execution() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) distinct (sqlspec.builder.SQLFactory.count parameter) (sqlspec.builder.SQLFactory.sum parameter) driver (sqlspec.driver._common.DataDictionaryMixin.detect_version_with_queries parameter) (sqlspec.driver._common.StackExecutionObserver attribute) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter parameter), [1] driver_features (sqlspec.adapters.adbc.AdbcConfig parameter) (sqlspec.adapters.adbc.AdbcDriver parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.aiosqlite.AiosqliteDriver parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.asyncpg.AsyncpgDriver parameter) (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.duckdb.DuckDBDriver parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) (sqlspec.adapters.sqlite.SqliteDriver parameter) (sqlspec.driver._common.CommonDriverAttributesMixin attribute) (sqlspec.driver._common.CommonDriverAttributesMixin parameter) driver_type (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) drop_index() (sqlspec.builder.SQLFactory method) drop_schema() (sqlspec.builder.SQLFactory method) drop_table() (sqlspec.builder.SQLFactory method) drop_view() (sqlspec.builder.SQLFactory method) dsn (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) DuckDBConfig (class in sqlspec.adapters.duckdb) DuckDBDriver (class in sqlspec.adapters.duckdb) DuckDBExtensionConfig (class in sqlspec.adapters.duckdb) DuckDBSecretConfig (class in sqlspec.adapters.duckdb)

E

enable_analysis (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) enable_caching (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) enable_expression_simplification (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) enable_parameter_type_wrapping (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) enable_parsing (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) enable_transformations (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) enable_validation (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) encoding (sqlspec.loader.SQLFileLoader attribute) (sqlspec.loader.SQLFileLoader parameter) error (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.StackResult attribute) error_code (sqlspec.extensions.adk._types.EventRecord attribute) error_message (sqlspec.extensions.adk._types.EventRecord attribute) errors (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) event (sqlspec.extensions.adk.converters.event_to_record parameter) (sqlspec.extensions.adk.SQLSpecSessionService.append_event parameter), [1] event_id (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.get_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] event_record (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.append_event parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.append_event parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.append_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.append_event parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.append_event parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.append_event parameter), [1] event_to_record() (in module sqlspec.extensions.adk.converters) EventRecord (class in sqlspec.extensions.adk._types) events (sqlspec.extensions.adk.converters.record_to_session parameter) events_table (sqlspec.extensions.adk.BaseAsyncADKStore property) (sqlspec.extensions.adk.BaseSyncADKStore property) evictions (sqlspec.core.cache.CacheStats attribute) execute() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method)

execute_many() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) execute_script() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) execute_stack() (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method), [1] (sqlspec.driver._sync.SyncDriverAdapterBase method), [1] execution_args (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) execution_mode (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) execution_parameters (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) execution_result (sqlspec.driver._common.CommonDriverAttributesMixin.build_statement_result parameter) execution_time (sqlspec.core.result.SQLResult parameter) ExecutionResult (class in sqlspec.driver._common) exists() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) exists_ (sqlspec.builder.SQLFactory property) expires_in (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.set parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.set parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.set parameter) expires_in() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) expression (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) (sqlspec.core.statement.SQL property) extend() (sqlspec.core.stack.StatementStack method) extension_config (sqlspec.adapters.adbc.AdbcConfig parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) extra (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) extract_parameters() (sqlspec.core.filters.LimitOffsetFilter method) (sqlspec.core.filters.OrderByFilter method) (sqlspec.core.filters.SearchFilter method) (sqlspec.core.filters.StatementFilter method) (sqlspec.core.parameters.ParameterValidator method)

F

field_name (sqlspec.core.filters.OrderByFilter property) (sqlspec.core.filters.SearchFilter property) filter_type (sqlspec.driver._common.CommonDriverAttributesMixin.find_filter parameter) filters (sqlspec.core.statement.SQL property) (sqlspec.driver._common.CommonDriverAttributesMixin.find_filter parameter) find_filter() (sqlspec.driver._common.CommonDriverAttributesMixin static method) for_key_share() (sqlspec.builder.Select method) for_no_key_update() (sqlspec.builder.Select method) for_share() (sqlspec.builder.Select method) for_update() (sqlspec.builder.Select method)

force_install (sqlspec.adapters.duckdb.DuckDBExtensionConfig attribute) fragment_cache_enabled (sqlspec.base.SQLSpec.configure_cache parameter) (sqlspec.core.cache.CacheConfig parameter) fragment_cache_size (sqlspec.base.SQLSpec.configure_cache parameter) (sqlspec.core.cache.CacheConfig parameter) from_arrow_result() (sqlspec.core.result.StackResult class method) from_error() (sqlspec.core.result.StackResult class method) from_operations() (sqlspec.core.stack.StatementStack class method) from_sql_result() (sqlspec.core.result.StackResult class method) full_join_ (sqlspec.builder.SQLFactory property)

G

get() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.core.cache.MultiLevelCache method) (sqlspec.core.cache.UnifiedCache method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) get_affected_count() (sqlspec.core.result.SQLResult method) get_annotation() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] get_annotations() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] get_cache_config() (sqlspec.base.SQLSpec static method) get_cache_key() (sqlspec.core.filters.LimitOffsetFilter method) (sqlspec.core.filters.OrderByFilter method) (sqlspec.core.filters.SearchFilter method) (sqlspec.core.filters.StatementFilter method) get_cache_stats() (sqlspec.base.SQLSpec static method) get_config() (sqlspec.base.SQLSpec method) (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] get_connection() (sqlspec.base.SQLSpec method) (sqlspec.extensions.starlette.SQLSpecPlugin method) get_count() (sqlspec.core.result.SQLResult method) get_data() (sqlspec.core.result.SQLResult method) get_default_features() (sqlspec.driver._common.DataDictionaryMixin method) get_default_type_mapping() (sqlspec.driver._common.DataDictionaryMixin method) get_events() (sqlspec.extensions.adk.BaseAsyncADKStore method) get_file() (sqlspec.loader.SQLFileLoader method) get_file_for_query() (sqlspec.loader.SQLFileLoader method) get_filters_view() (sqlspec.core.statement.SQL method) get_first() (sqlspec.core.result.SQLResult method)

get_insert_expression() (sqlspec.builder.Insert method) get_metadata() (sqlspec.core.result.SQLResult method) get_param_name() (sqlspec.core.filters.SearchFilter method) get_param_names() (sqlspec.core.filters.LimitOffsetFilter method) get_pool() (sqlspec.base.SQLSpec method) get_processed_state() (sqlspec.core.statement.SQL method) get_query_text() (sqlspec.loader.SQLFileLoader method) get_result() (sqlspec.core.result.StackResult method) get_session() (sqlspec.base.SQLSpec method) (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) (sqlspec.extensions.adk.SQLSpecSessionService method) (sqlspec.extensions.starlette.SQLSpecPlugin method) get_signature_namespace() (sqlspec.adapters.adbc.AdbcConfig method) (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) (sqlspec.adapters.duckdb.DuckDBConfig method) (sqlspec.adapters.sqlite.SqliteConfig method) get_sql() (sqlspec.base.SQLSpec method) (sqlspec.loader.SQLFileLoader method) get_sql_files() (sqlspec.base.SQLSpec method) get_sqlglot_compatible_sql() (sqlspec.core.parameters.ParameterProcessor method) get_sqlglot_incompatible_styles() (sqlspec.core.parameters.ParameterValidator method) get_stats() (sqlspec.core.cache.MultiLevelCache method) (sqlspec.core.cache.UnifiedCache method) get_total_rows_affected() (sqlspec.core.result.SQLResult method) grounding_metadata (sqlspec.extensions.adk._types.EventRecord attribute) grouping_sets() (sqlspec.builder.SQLFactory static method)

H

handle_database_exceptions() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) handle_single_row_error() (in module sqlspec.driver._common) has_errors (sqlspec.core.statement.SQL property)

has_more (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) has_native_list_expansion (sqlspec.core.parameters.ParameterStyleConfig attribute) has_query() (sqlspec.loader.SQLFileLoader method) has_sql_query() (sqlspec.base.SQLSpec method) hash() (sqlspec.core.parameters.ParameterStyleConfig method) hash_stack_operations() (in module sqlspec.driver._common) hashed_operations (sqlspec.driver._common.StackExecutionObserver attribute) hint (sqlspec.builder.Select.with_hint parameter) hit_rate (sqlspec.core.cache.CacheStats property) hits (sqlspec.core.cache.CacheStats attribute) host (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute)

I

id (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk._types.SessionRecord attribute) ignore_case (sqlspec.core.filters.SearchFilter property) in_ (sqlspec.builder.SQLFactory property) include_redirect (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware parameter) index (sqlspec.core.result.SQLResult.__getitem__ parameter) index_name (sqlspec.builder.SQLFactory.create_index parameter) (sqlspec.builder.SQLFactory.drop_index parameter) init (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) init_app() (sqlspec.extensions.starlette.SQLSpecPlugin method) inner_join_ (sqlspec.builder.SQLFactory property) Insert (class in sqlspec.builder) insert() (sqlspec.builder.SQLFactory method) insert_returning() (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] insert_update_delete() (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] insert_update_delete_many() (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] inserted_ids (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) interrupted (sqlspec.extensions.adk._types.EventRecord attribute) invocation_id (sqlspec.extensions.adk._types.EventRecord attribute)

is_aio_driver (sqlspec.extensions.aiosql.AiosqlAsyncAdapter attribute), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter attribute), [1] is_arrow_result() (sqlspec.core.result.StackResult method) is_async (sqlspec.driver._async.AsyncDriverAdapterBase attribute) (sqlspec.driver._sync.SyncDriverAdapterBase attribute) is_empty() (sqlspec.core.cache.UnifiedCache method) (sqlspec.core.result.SQLResult method) is_error() (sqlspec.core.result.StackResult method) is_many (sqlspec.adapters.adbc.AdbcDriver.prepare_driver_parameters parameter) (sqlspec.core.compiler.SQLProcessor.compile parameter) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL property) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_driver_parameters parameter) is_many_result (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) is_modifying_operation() (sqlspec.core.statement.SQL method) is_processed (sqlspec.core.statement.SQL property) is_script (sqlspec.core.statement.SQL property) is_script_result (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) is_select_result (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) is_sql_result() (sqlspec.core.result.StackResult method) is_success() (sqlspec.core.result.SQLResult method)

J

join() (sqlspec.builder.Update method) join_type (sqlspec.builder.Update.join parameter)

json_deserializer (sqlspec.core.parameters.ParameterStyleConfig attribute) json_serializer (sqlspec.core.parameters.ParameterStyleConfig attribute)

K

key (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.delete parameter) (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.exists parameter) (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.expires_in parameter) (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.get parameter) (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.set parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.delete parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.exists parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.expires_in parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.get parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.set parameter) (sqlspec.core.cache.MultiLevelCache.delete parameter) (sqlspec.core.cache.MultiLevelCache.get parameter) (sqlspec.core.cache.MultiLevelCache.put parameter) (sqlspec.core.cache.UnifiedCache.delete parameter) (sqlspec.core.cache.UnifiedCache.get parameter) (sqlspec.core.cache.UnifiedCache.put parameter) (sqlspec.core.result.SQLResult.get_metadata parameter) (sqlspec.core.result.SQLResult.set_metadata parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.delete parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.exists parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.expires_in parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.get parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.set parameter) (sqlspec.extensions.litestar.SQLSpecPlugin.get_annotation parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_async_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_sync_request_session parameter), [1] (sqlspec.extensions.starlette.SQLSpecPlugin.get_connection parameter) (sqlspec.extensions.starlette.SQLSpecPlugin.get_session parameter)

key_data (sqlspec.core.cache.CacheKey parameter), [1] (sqlspec.core.cache.CacheKey property) keyword_arguments (sqlspec.core.stack.StackOperation attribute) kwargs (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_statement parameter)

L

lag_ (sqlspec.builder.SQLFactory property) last_inserted_id (sqlspec.core.result.SQLResult parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) lateral_join_ (sqlspec.builder.SQLFactory property) lead_ (sqlspec.builder.SQLFactory property) left_join_ (sqlspec.builder.SQLFactory property) left_lateral_join_ (sqlspec.builder.SQLFactory property) length() (sqlspec.builder.SQLFactory static method) level (sqlspec.core.cache.MultiLevelCache.delete parameter) (sqlspec.core.cache.MultiLevelCache.get parameter) (sqlspec.core.cache.MultiLevelCache.put parameter) lifespan() (sqlspec.extensions.starlette.SQLSpecPlugin method) limit (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.get_events parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.get_events parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.get_events parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.get_events parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.get_events parameter) (sqlspec.core.filters.LimitOffsetFilter property) (sqlspec.extensions.adk.BaseAsyncADKStore.get_events parameter), [1] LimitOffsetFilter (class in sqlspec.core.filters) list_events() (sqlspec.extensions.adk.BaseSyncADKStore method) list_files() (sqlspec.loader.SQLFileLoader method) list_queries() (sqlspec.loader.SQLFileLoader method) list_sessions() (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) (sqlspec.extensions.adk.SQLSpecSessionService method)

list_sql_queries() (sqlspec.base.SQLSpec method) load_from_arrow() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) load_from_storage() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) load_sql() (sqlspec.loader.SQLFileLoader method) load_sql_files() (sqlspec.base.SQLSpec method) loader (sqlspec.extensions.litestar.SQLSpecPlugin parameter), [1] location (sqlspec.builder.Select.with_hint parameter) log_cache_stats() (sqlspec.base.SQLSpec static method) long_running_tool_ids_json (sqlspec.extensions.adk._types.EventRecord attribute) loop (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) lower() (sqlspec.builder.SQLFactory static method)

M

major (sqlspec.driver._common.VersionInfo parameter) make_cache_key_hashable() (in module sqlspec.driver._common) max() (sqlspec.builder.SQLFactory static method) max_cache_size (sqlspec.core.compiler.SQLProcessor parameter) max_cacheable_statement_size (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) max_cached_statement_lifetime (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) max_inactive_connection_lifetime (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) max_queries (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) max_size (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) (sqlspec.core.cache.MultiLevelCache parameter) (sqlspec.core.cache.UnifiedCache parameter), [1] memory_usage (sqlspec.core.cache.CacheStats attribute) Merge (class in sqlspec.builder) merge() (sqlspec.builder.SQLFactory method) merge_ (sqlspec.builder.SQLFactory property) metadata (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.StackResult attribute)

method (sqlspec.core.stack.StackOperation attribute) metrics (sqlspec.driver._common.StackExecutionObserver attribute) migration_config (sqlspec.adapters.adbc.AdbcConfig parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) min() (sqlspec.builder.SQLFactory static method) min_size (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) minor (sqlspec.driver._common.VersionInfo parameter) miss_rate (sqlspec.core.cache.CacheStats property) misses (sqlspec.core.cache.CacheStats attribute) module sqlspec.driver._common sqlspec.extensions.aiosql sqlspec.extensions.starlette MultiLevelCache (class in sqlspec.core.cache)

N

name (sqlspec.adapters.duckdb.DuckDBExtensionConfig attribute) (sqlspec.adapters.duckdb.DuckDBSecretConfig attribute) (sqlspec.base.SQLSpec.add_named_sql parameter) (sqlspec.base.SQLSpec.close_pool parameter) (sqlspec.base.SQLSpec.get_config parameter) (sqlspec.base.SQLSpec.get_connection parameter) (sqlspec.base.SQLSpec.get_pool parameter) (sqlspec.base.SQLSpec.get_session parameter) (sqlspec.base.SQLSpec.get_sql parameter) (sqlspec.base.SQLSpec.has_sql_query parameter) (sqlspec.base.SQLSpec.provide_connection parameter) (sqlspec.base.SQLSpec.provide_session parameter) (sqlspec.builder.SQLFactory.__getattr__ parameter) (sqlspec.builder.SQLFactory.column parameter) (sqlspec.core.statement.SQL.add_named_parameter parameter) (sqlspec.extensions.litestar.SQLSpecPlugin.get_config parameter), [1] (sqlspec.loader.SQLFileLoader.add_named_sql parameter) (sqlspec.loader.SQLFileLoader.get_file_for_query parameter) (sqlspec.loader.SQLFileLoader.get_query_text parameter) (sqlspec.loader.SQLFileLoader.get_sql parameter) (sqlspec.loader.SQLFileLoader.has_query parameter)

NAMED_AT (sqlspec.core.parameters.ParameterStyle attribute) NAMED_COLON (sqlspec.core.parameters.ParameterStyle attribute) NAMED_DOLLAR (sqlspec.core.parameters.ParameterStyle attribute) named_parameters (sqlspec.core.statement.SQL property) NAMED_PYFORMAT (sqlspec.core.parameters.ParameterStyle attribute) native_only (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) native_pipeline (sqlspec.driver._common.StackExecutionObserver attribute) needs_static_script_compilation (sqlspec.core.parameters.ParameterStyleConfig attribute) NONE (sqlspec.core.parameters.ParameterStyle attribute) normalize_sql_for_parsing() (sqlspec.core.parameters.ParameterConverter method) not_any_() (sqlspec.builder.SQLFactory static method) nowait (sqlspec.builder.Select.for_share parameter) (sqlspec.builder.Select.for_update parameter) num_columns (sqlspec.core.result.SQLResult property) num_rows (sqlspec.core.result.SQLResult property) NUMERIC (sqlspec.core.parameters.ParameterStyle attribute) nvl() (sqlspec.builder.SQLFactory static method) nvl2() (sqlspec.builder.SQLFactory static method)

O

obj (sqlspec.driver._common.make_cache_key_hashable parameter) observability (sqlspec.adapters.adbc.AdbcDriver parameter) (sqlspec.adapters.aiosqlite.AiosqliteDriver parameter) (sqlspec.adapters.asyncpg.AsyncpgDriver parameter) (sqlspec.adapters.duckdb.DuckDBDriver parameter) (sqlspec.driver._common.CommonDriverAttributesMixin parameter) (sqlspec.driver._common.CommonDriverAttributesMixin property) observability_config (sqlspec.adapters.adbc.AdbcConfig parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) of (sqlspec.builder.Select.for_share parameter) (sqlspec.builder.Select.for_update parameter) offset (sqlspec.core.filters.LimitOffsetFilter property) old_name (sqlspec.builder.SQLFactory.rename_table parameter) on (sqlspec.builder.Update.join parameter) on_app_init() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] on_cli_init() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] on_conflict() (sqlspec.builder.Insert method) on_conflict_do_nothing() (sqlspec.builder.Insert method) on_duplicate_key_update() (sqlspec.builder.Insert method) one() (sqlspec.core.result.SQLResult method) one_or_none() (sqlspec.core.result.SQLResult method) operation_index (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) operation_profile (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) operation_type (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.SQLResult property) (sqlspec.core.statement.SQL property)

operations (sqlspec.core.stack.StatementStack property) OperationType (in module sqlspec.core.compiler) optimized_cache_enabled (sqlspec.base.SQLSpec.configure_cache parameter) (sqlspec.core.cache.CacheConfig parameter) optimized_cache_size (sqlspec.base.SQLSpec.configure_cache parameter) (sqlspec.core.cache.CacheConfig parameter) order_by (sqlspec.builder.SQLFactory.dense_rank parameter) (sqlspec.builder.SQLFactory.rank parameter) (sqlspec.builder.SQLFactory.row_number parameter) OrderByFilter (class in sqlspec.core.filters) original_parameters (sqlspec.core.statement.SQL property) output_transformer (sqlspec.core.parameters.ParameterStyleConfig attribute) (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) owner_id (sqlspec.adapters.adbc.adk.AdbcADKStore.create_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.create_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.create_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.create_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter), [1] owner_id_column_ddl (sqlspec.extensions.adk.BaseAsyncADKStore property) (sqlspec.extensions.adk.BaseSyncADKStore property) owner_id_column_name (sqlspec.extensions.adk.BaseAsyncADKStore property) (sqlspec.extensions.adk.BaseSyncADKStore property)

P

parameter_casts (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) parameter_config (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) parameter_converter (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) parameter_profile (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) parameter_style (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) parameter_validator (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) ParameterConverter (class in sqlspec.core.parameters) ParameterProcessor (class in sqlspec.core.parameters) parameters (sqlspec.adapters.adbc.AdbcDriver.prepare_driver_parameters parameter) (sqlspec.core.compiler.SQLProcessor.compile parameter) (sqlspec.core.parameters.ParameterProcessor.get_sqlglot_compatible_sql parameter) (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.statement.SQL property) (sqlspec.core.statement.SQL.copy parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_driver_parameters parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_statement parameter) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_value parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_value parameter), [1] ParameterStyle (class in sqlspec.core.parameters) ParameterStyleConfig (class in sqlspec.core.parameters) ParameterValidator (class in sqlspec.core.parameters) parse_version_string() (sqlspec.driver._common.DataDictionaryMixin method) partial (sqlspec.extensions.adk._types.EventRecord attribute) partition_by (sqlspec.builder.SQLFactory.dense_rank parameter) (sqlspec.builder.SQLFactory.rank parameter) (sqlspec.builder.SQLFactory.row_number parameter) passfile (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) password (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) patch (sqlspec.driver._common.VersionInfo parameter) path (sqlspec.loader.SQLFileLoader.get_file parameter) placeholder_style (sqlspec.builder.SQLFactory.bulk_insert parameter) pool_config (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.sqlite.SqliteConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig parameter)

pool_instance (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) port (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) POSITIONAL_COLON (sqlspec.core.parameters.ParameterStyle attribute) positional_parameters (sqlspec.core.statement.SQL property) POSITIONAL_PYFORMAT (sqlspec.core.parameters.ParameterStyle attribute) post_process_steps (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) pre_process_steps (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) prepare_driver_parameters() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.driver._common.CommonDriverAttributesMixin method) prepare_statement() (sqlspec.driver._common.CommonDriverAttributesMixin method) prepared_statement (sqlspec.adapters.adbc.AdbcDriver.prepare_driver_parameters parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_driver_parameters parameter) preserve_original_params_for_many (sqlspec.core.parameters.ParameterStyleConfig attribute) preserve_parameter_format (sqlspec.core.parameters.ParameterStyleConfig attribute) process() (sqlspec.core.parameters.ParameterProcessor method) provide_async_request_session() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] provide_connection() (sqlspec.adapters.adbc.AdbcConfig method) (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) (sqlspec.adapters.duckdb.DuckDBConfig method) (sqlspec.adapters.sqlite.SqliteConfig method) (sqlspec.base.SQLSpec method) provide_pool() (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) provide_request_connection() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] provide_request_session() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] provide_session() (sqlspec.adapters.adbc.AdbcConfig method) (sqlspec.adapters.aiosqlite.AiosqliteConfig method) (sqlspec.adapters.asyncpg.AsyncpgConfig method) (sqlspec.adapters.duckdb.DuckDBConfig method) (sqlspec.adapters.sqlite.SqliteConfig method) (sqlspec.base.SQLSpec method) provide_sync_request_session() (sqlspec.extensions.litestar.SQLSpecPlugin method), [1] PsycopgAsyncDriver (class in sqlspec.adapters.psycopg) PsycopgSyncDriver (class in sqlspec.adapters.psycopg) push_execute() (sqlspec.core.stack.StatementStack method) push_execute_arrow() (sqlspec.core.stack.StatementStack method) push_execute_many() (sqlspec.core.stack.StatementStack method) push_execute_script() (sqlspec.core.stack.StatementStack method) put() (sqlspec.core.cache.MultiLevelCache method) (sqlspec.core.cache.UnifiedCache method)

Q

QMARK (sqlspec.core.parameters.ParameterStyle attribute) queries (sqlspec.driver._common.DataDictionaryMixin.detect_version_with_queries parameter) query_name (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_value parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_value parameter), [1]

R

rank() (sqlspec.builder.SQLFactory method) rank_ (sqlspec.builder.SQLFactory property) raw() (sqlspec.builder.SQLFactory static method) raw_sql (sqlspec.core.statement.SQL property) record (sqlspec.extensions.adk.converters.record_to_event parameter) (sqlspec.extensions.adk.converters.record_to_session parameter) record_class (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_one parameter), [1] record_eviction() (sqlspec.core.cache.CacheStats method) record_hit() (sqlspec.core.cache.CacheStats method) record_miss() (sqlspec.core.cache.CacheStats method) record_operation_error() (sqlspec.driver._common.StackExecutionObserver method) record_to_event() (in module sqlspec.extensions.adk.converters) record_to_session() (in module sqlspec.extensions.adk.converters) reload_sql_files() (sqlspec.base.SQLSpec method) rename_table() (sqlspec.builder.SQLFactory method) renew_for (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.get parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.get parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.get parameter) replace() (sqlspec.core.parameters.ParameterStyleConfig method) (sqlspec.core.statement.StatementConfig method) repository (sqlspec.adapters.duckdb.DuckDBExtensionConfig attribute) request (sqlspec.extensions.starlette.SQLSpecAutocommitMiddleware.dispatch parameter) (sqlspec.extensions.starlette.SQLSpecManualMiddleware.dispatch parameter) (sqlspec.extensions.starlette.SQLSpecPlugin.get_connection parameter) (sqlspec.extensions.starlette.SQLSpecPlugin.get_session parameter) reset() (sqlspec.core.cache.CacheStats method)

reset_cache_stats() (sqlspec.base.SQLSpec static method) result (sqlspec.core.result.SQLResult.add_statement_result parameter) (sqlspec.core.result.StackResult attribute) result_type (sqlspec.core.result.StackResult property) return_format (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) returns_rows() (sqlspec.core.statement.SQL method) right_join_ (sqlspec.builder.SQLFactory property) rollback() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) rollup() (sqlspec.builder.SQLFactory static method) round() (sqlspec.builder.SQLFactory static method) row_number() (sqlspec.builder.SQLFactory method) row_number_ (sqlspec.builder.SQLFactory property) rowcount_override (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) (sqlspec.driver._common.ScriptExecutionResult attribute) rows_affected (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.StackResult attribute) runtime (sqlspec.driver._common.StackExecutionObserver attribute) (sqlspec.loader.SQLFileLoader parameter)

S

scalar() (sqlspec.core.result.SQLResult method) scalar_or_none() (sqlspec.core.result.SQLResult method) schema_name (sqlspec.builder.SQLFactory.create_schema parameter) (sqlspec.builder.SQLFactory.drop_schema parameter) schema_type (sqlspec.core.result.SQLResult.all parameter) (sqlspec.core.result.SQLResult.get_data parameter) (sqlspec.core.result.SQLResult.get_first parameter) (sqlspec.core.result.SQLResult.one parameter) (sqlspec.core.result.SQLResult.one_or_none parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_with_total parameter) scope (sqlspec.adapters.duckdb.DuckDBSecretConfig attribute) (sqlspec.extensions.litestar.SQLSpecPlugin.provide_async_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_sync_request_session parameter), [1] script (sqlspec.driver._common.CommonDriverAttributesMixin.split_script_statements parameter) ScriptExecutionResult (class in sqlspec.driver._common) SearchFilter (class in sqlspec.core.filters) secret_type (sqlspec.adapters.duckdb.DuckDBSecretConfig attribute) Select (class in sqlspec.builder) select() (sqlspec.builder.SQLFactory method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] select_cursor() (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] select_one() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] select_one_or_none() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) select_to_arrow() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) select_to_storage() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) select_value() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter method), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter method), [1] select_value_or_none() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) select_with_total() (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method) selected_data (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) server_settings (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) session (sqlspec.extensions.adk.converters.session_to_record parameter) (sqlspec.extensions.adk.SQLSpecSessionService.append_event parameter), [1] session_id (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.create_session parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.delete_session parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.get_session parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.list_events parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.update_session_state parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.create_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.delete_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.get_events parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.get_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.update_session_state parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.create_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.delete_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.get_events parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.get_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.update_session_state parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.delete_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.get_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.list_events parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.update_session_state parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.delete_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.get_events parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.get_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.update_session_state parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.delete_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.get_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.list_events parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.update_session_state parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.delete_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.get_events parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.get_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.update_session_state parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.delete_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.get_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.list_events parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.update_session_state parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.create_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.delete_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.get_events parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.get_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.update_session_state parameter) (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.delete_session parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.get_events parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.get_session parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.update_session_state parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.delete_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.get_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.list_events parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.update_session_state parameter), [1] (sqlspec.extensions.adk.converters.event_to_record parameter) (sqlspec.extensions.adk.SQLSpecSessionService.create_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.delete_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.get_session parameter), [1] session_table (sqlspec.extensions.adk.BaseAsyncADKStore property) (sqlspec.extensions.adk.BaseSyncADKStore property) session_to_record() (in module sqlspec.extensions.adk.converters) SessionRecord (class in sqlspec.extensions.adk._types) set() (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore method) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore method) (sqlspec.extensions.litestar.BaseSQLSpecStore method) set_metadata() (sqlspec.core.result.SQLResult method) set_observability_runtime() (sqlspec.loader.SQLFileLoader method) setup (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) size() (sqlspec.core.cache.UnifiedCache method) skip_locked (sqlspec.builder.Select.for_share parameter) (sqlspec.builder.Select.for_update parameter) sort_order (sqlspec.core.filters.OrderByFilter property) span (sqlspec.driver._common.StackExecutionObserver attribute) special_data (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) (sqlspec.driver._common.ScriptExecutionResult attribute) split_script_statements() (sqlspec.driver._common.CommonDriverAttributesMixin method) SQL (class in sqlspec.core.statement) sql (sqlspec.base.SQLSpec.add_named_sql parameter) (sqlspec.core.compiler.SQLProcessor.compile parameter) (sqlspec.core.parameters.ParameterProcessor.get_sqlglot_compatible_sql parameter) (sqlspec.core.statement.SQL property) (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlAsyncAdapter.select_value parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_returning parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.insert_update_delete_many parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_cursor parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_one parameter), [1] (sqlspec.extensions.aiosql.AiosqlSyncAdapter.select_value parameter), [1] (sqlspec.loader.SQLFileLoader.add_named_sql parameter)

sql_cache_enabled (sqlspec.base.SQLSpec.configure_cache parameter) (sqlspec.core.cache.CacheConfig parameter) sql_cache_size (sqlspec.base.SQLSpec.configure_cache parameter) (sqlspec.core.cache.CacheConfig parameter) sql_fragment (sqlspec.builder.SQLFactory.raw parameter) SQLFactory (class in sqlspec.builder) SQLFileLoader (class in sqlspec.loader) SqliteConfig (class in sqlspec.adapters.sqlite) SqliteDriver (class in sqlspec.adapters.sqlite) SQLProcessor (class in sqlspec.core.compiler) SQLResult (class in sqlspec.core.result) SQLSpec (class in sqlspec.base) sqlspec (sqlspec.extensions.litestar.SQLSpecPlugin parameter), [1] (sqlspec.extensions.starlette.SQLSpecPlugin parameter) sqlspec.driver._common module sqlspec.extensions.aiosql module sqlspec.extensions.starlette module SQLSpecAutocommitMiddleware (class in sqlspec.extensions.starlette) SQLSpecManualMiddleware (class in sqlspec.extensions.starlette) SQLSpecPlugin (class in sqlspec.extensions.litestar), [1] (class in sqlspec.extensions.starlette) SQLSpecSessionService (class in sqlspec.extensions.adk) ssl (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) stack (sqlspec.driver._common.StackExecutionObserver attribute) stack_native_disabled (sqlspec.driver._common.CommonDriverAttributesMixin property) StackExecutionError (class in sqlspec.exceptions) StackExecutionObserver (class in sqlspec.driver._common) StackOperation (class in sqlspec.core.stack) StackResult (class in sqlspec.core.result) started (sqlspec.driver._common.StackExecutionObserver attribute) state (sqlspec.adapters.adbc.adk.AdbcADKStore.create_session parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.update_session_state parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.create_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.update_session_state parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.create_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.update_session_state parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.update_session_state parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.update_session_state parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.update_session_state parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.update_session_state parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.update_session_state parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.create_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.update_session_state parameter) (sqlspec.extensions.adk._types.SessionRecord attribute) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.update_session_state parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.update_session_state parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.create_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_async_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_sync_request_session parameter), [1] statement (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.builder.SQLFactory.__call__ parameter) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.stack.StackOperation attribute) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL.copy parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.dispatch_statement_execution parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.build_statement_result parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_statement parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.dispatch_statement_execution parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_with_total parameter) statement_cache_size (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) statement_config (sqlspec.adapters.adbc.AdbcConfig parameter) (sqlspec.adapters.adbc.AdbcConfig.provide_session parameter) (sqlspec.adapters.adbc.AdbcDriver parameter) (sqlspec.adapters.adbc.AdbcDriver.prepare_driver_parameters parameter) (sqlspec.adapters.adbc.AdbcDriver.select_to_arrow parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig parameter) (sqlspec.adapters.aiosqlite.AiosqliteConfig.provide_session parameter) (sqlspec.adapters.aiosqlite.AiosqliteDriver parameter) (sqlspec.adapters.asyncpg.AsyncpgConfig parameter), [1] (sqlspec.adapters.asyncpg.AsyncpgConfig.provide_session parameter), [1] (sqlspec.adapters.asyncpg.AsyncpgDriver parameter) (sqlspec.adapters.duckdb.DuckDBConfig parameter) (sqlspec.adapters.duckdb.DuckDBConfig.provide_session parameter) (sqlspec.adapters.duckdb.DuckDBDriver parameter) (sqlspec.adapters.duckdb.DuckDBDriver.select_to_arrow parameter) (sqlspec.adapters.sqlite.SqliteConfig parameter) (sqlspec.adapters.sqlite.SqliteDriver parameter) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL property) (sqlspec.driver._async.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._async.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver._common.CommonDriverAttributesMixin attribute) (sqlspec.driver._common.CommonDriverAttributesMixin parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_driver_parameters parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.prepare_statement parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.split_script_statements parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver._sync.SyncDriverAdapterBase.select_with_total parameter) statement_count (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) (sqlspec.driver._common.ScriptExecutionResult attribute) statement_expression (sqlspec.core.statement.SQL property) statement_results (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) StatementConfig (class in sqlspec.core.statement) StatementFilter (class in sqlspec.core.filters) StatementStack (class in sqlspec.core.stack) STATIC (sqlspec.core.parameters.ParameterStyle attribute) storage_partition_strategies (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) storage_registry (sqlspec.loader.SQLFileLoader attribute) (sqlspec.loader.SQLFileLoader parameter) store (sqlspec.extensions.adk.SQLSpecSessionService parameter), [1], [2], [3] (sqlspec.extensions.adk.SQLSpecSessionService property) strip_trailing_semicolon (sqlspec.driver._common.CommonDriverAttributesMixin.split_script_statements parameter) substitute_value (sqlspec.builder.SQLFactory.nvl parameter) successful_statements (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) (sqlspec.driver._common.CommonDriverAttributesMixin.create_execution_result parameter) (sqlspec.driver._common.ExecutionResult attribute) (sqlspec.driver._common.ScriptExecutionResult attribute) sum() (sqlspec.builder.SQLFactory static method) supported_execution_parameter_styles (sqlspec.core.parameters.ParameterStyleConfig attribute) supported_parameter_styles (sqlspec.core.parameters.ParameterStyleConfig attribute) supports_many (sqlspec.core.compiler.CompiledSQL attribute) (sqlspec.core.compiler.CompiledSQL parameter) supports_native_arrow_export (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) supports_native_arrow_import (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) supports_native_parquet_export (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) supports_native_parquet_import (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) supports_transactional_ddl (sqlspec.adapters.adbc.AdbcConfig attribute) (sqlspec.adapters.aiosqlite.AiosqliteConfig attribute) (sqlspec.adapters.asyncpg.AsyncpgConfig attribute) (sqlspec.adapters.duckdb.DuckDBConfig attribute) (sqlspec.adapters.sqlite.SqliteConfig attribute) SyncDriverAdapterBase (class in sqlspec.driver._sync)

T

table (sqlspec.builder.Delete parameter) (sqlspec.builder.Insert parameter) (sqlspec.builder.Select.with_hint parameter) (sqlspec.builder.SQLFactory.column parameter) (sqlspec.builder.SQLFactory.upsert parameter) (sqlspec.builder.Update parameter) (sqlspec.builder.Update.join parameter) table_name (sqlspec.builder.SQLFactory.alter_table parameter) (sqlspec.builder.SQLFactory.bulk_insert parameter) (sqlspec.builder.SQLFactory.create_table parameter) (sqlspec.builder.SQLFactory.drop_table parameter) (sqlspec.builder.SQLFactory.truncate parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore property)

target_table (sqlspec.builder.Merge parameter) telemetry_snapshot() (sqlspec.base.SQLSpec method) timestamp (sqlspec.extensions.adk._types.EventRecord attribute) to_literal() (sqlspec.builder.SQLFactory static method) total_count (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) total_operations (sqlspec.core.cache.CacheStats attribute) total_statements (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) truncate() (sqlspec.builder.SQLFactory method) ttl_seconds (sqlspec.core.cache.MultiLevelCache parameter) (sqlspec.core.cache.UnifiedCache parameter), [1] turn_complete (sqlspec.extensions.adk._types.EventRecord attribute) type_coercion_map (sqlspec.core.parameters.ParameterStyleConfig attribute)

U

UnifiedCache (class in sqlspec.core.cache) Update (class in sqlspec.builder) update() (sqlspec.builder.SQLFactory method) update_cache_config() (sqlspec.base.SQLSpec static method) update_session_state() (sqlspec.extensions.adk.BaseAsyncADKStore method) (sqlspec.extensions.adk.BaseSyncADKStore method) update_time (sqlspec.extensions.adk._types.SessionRecord attribute) upper() (sqlspec.builder.SQLFactory static method) upsert() (sqlspec.builder.SQLFactory method) user (sqlspec.adapters.asyncpg.AsyncpgPoolConfig attribute) user_id (sqlspec.adapters.adbc.adk.AdbcADKStore.create_event parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.create_session parameter) (sqlspec.adapters.adbc.adk.AdbcADKStore.list_sessions parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.create_session parameter) (sqlspec.adapters.aiosqlite.adk.AiosqliteADKStore.list_sessions parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.create_session parameter) (sqlspec.adapters.asyncpg.adk.AsyncpgADKStore.list_sessions parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_event parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.create_session parameter) (sqlspec.adapters.duckdb.adk.DuckdbADKStore.list_sessions parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleAsyncADKStore.list_sessions parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_event parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.create_session parameter) (sqlspec.adapters.oracledb.adk.OracleSyncADKStore.list_sessions parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgAsyncADKStore.list_sessions parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_event parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.create_session parameter) (sqlspec.adapters.psycopg.adk.PsycopgSyncADKStore.list_sessions parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.create_session parameter) (sqlspec.adapters.sqlite.adk.SqliteADKStore.list_sessions parameter) (sqlspec.extensions.adk._types.EventRecord attribute) (sqlspec.extensions.adk._types.SessionRecord attribute) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore.list_sessions parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore.list_sessions parameter), [1] (sqlspec.extensions.adk.converters.event_to_record parameter) (sqlspec.extensions.adk.SQLSpecSessionService.create_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.delete_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.get_session parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.list_sessions parameter), [1]

V

validation_errors (sqlspec.core.statement.SQL property) validator (sqlspec.core.parameters.ParameterConverter attribute) value (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.set parameter) (sqlspec.adapters.asyncpg.litestar.AsyncpgStore.set parameter) (sqlspec.adapters.duckdb.DuckDBSecretConfig attribute) (sqlspec.builder.SQLFactory.to_literal parameter) (sqlspec.core.cache.MultiLevelCache.put parameter) (sqlspec.core.cache.UnifiedCache.put parameter) (sqlspec.core.filters.SearchFilter property) (sqlspec.core.result.SQLResult.set_metadata parameter) (sqlspec.core.statement.SQL.add_named_parameter parameter) (sqlspec.core.type_conversion.BaseTypeConverter.convert_if_detected parameter) (sqlspec.core.type_conversion.BaseTypeConverter.convert_value parameter) (sqlspec.core.type_conversion.BaseTypeConverter.detect_type parameter) (sqlspec.extensions.litestar.BaseSQLSpecStore.set parameter)

value_if_not_null (sqlspec.builder.SQLFactory.nvl2 parameter) value_if_null (sqlspec.builder.SQLFactory.nvl2 parameter) values (sqlspec.builder.SQLFactory.any parameter) (sqlspec.builder.SQLFactory.not_any_ parameter) values_from_dict() (sqlspec.builder.Insert method) values_from_dicts() (sqlspec.builder.Insert method) version (sqlspec.adapters.duckdb.DuckDBExtensionConfig attribute) version_str (sqlspec.driver._common.DataDictionaryMixin.parse_version_string parameter) version_tuple (sqlspec.driver._common.VersionInfo property) VersionInfo (class in sqlspec.driver._common) view_name (sqlspec.builder.SQLFactory.create_materialized_view parameter) (sqlspec.builder.SQLFactory.create_view parameter) (sqlspec.builder.SQLFactory.drop_view parameter)

W

warning (sqlspec.core.result.StackResult attribute) was_deleted() (sqlspec.core.result.SQLResult method) was_inserted() (sqlspec.core.result.SQLResult method) was_updated() (sqlspec.core.result.SQLResult method) where() (sqlspec.core.statement.SQL method) with_cursor() (sqlspec.adapters.adbc.AdbcDriver method) (sqlspec.adapters.aiosqlite.AiosqliteDriver method) (sqlspec.adapters.asyncpg.AsyncpgDriver method) (sqlspec.adapters.duckdb.DuckDBDriver method) (sqlspec.adapters.psycopg.PsycopgAsyncDriver method) (sqlspec.adapters.psycopg.PsycopgSyncDriver method) (sqlspec.adapters.sqlite.SqliteDriver method) (sqlspec.driver._async.AsyncDriverAdapterBase method) (sqlspec.driver._sync.SyncDriverAdapterBase method)

with_error() (sqlspec.core.result.StackResult method) with_hint() (sqlspec.builder.Select method) with_json_serializers() (sqlspec.core.parameters.ParameterStyleConfig method) write_to_storage_async() (sqlspec.core.result.SQLResult method) write_to_storage_sync() (sqlspec.core.result.SQLResult method)