Index Symbols | _ | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W Symbols **kwargs (sqlspec.base.SQLSpec.provide_connection parameter) (sqlspec.base.SQLSpec.provide_session parameter) (sqlspec.builder.Select parameter) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL.copy parameter) (sqlspec.core.statement.StatementConfig.replace parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.SyncDriverAdapterBase.select_with_total parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) **parameters (sqlspec.builder.SQLFactory.raw parameter) *args (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.Select parameter) (sqlspec.builder.SQLFactory.cube parameter) (sqlspec.builder.SQLFactory.rollup parameter) (sqlspec.core.statement.SQL.select_only parameter) *expressions (sqlspec.builder.SQLFactory.coalesce parameter) (sqlspec.builder.SQLFactory.concat parameter) *items (sqlspec.core.statement.SQL.order_by parameter) *parameters (sqlspec.core.statement.SQL parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.SyncDriverAdapterBase.select_with_total parameter) *paths (sqlspec.base.SQLSpec.load_sql_files parameter) _ __aenter__() (sqlspec.base.SQLSpec method) __aexit__() (sqlspec.base.SQLSpec method) __call__() (sqlspec.builder.SQLFactory method) __eq__() (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) __getattr__() (sqlspec.builder.SQLFactory method) __getitem__() (sqlspec.core.result.SQLResult method) __hash__() (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) __init__() (sqlspec.base.SQLSpec method) (sqlspec.builder.Select method) (sqlspec.builder.SQLFactory 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.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) (sqlspec.exceptions.StackExecutionError method) __iter__() (sqlspec.core.result.SQLResult method) __len__() (sqlspec.core.result.SQLResult method) __new__() (sqlspec.core.parameters.ParameterStyle method) __repr__() (sqlspec.core.statement.SQL method) (sqlspec.core.statement.StatementConfig method) A actions (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) add_config() (sqlspec.base.SQLSpec method) add_named_parameter() (sqlspec.core.statement.SQL method) add_named_sql() (sqlspec.base.SQLSpec method) add_statement_result() (sqlspec.core.result.SQLResult method) after_timestamp (sqlspec.extensions.adk.BaseAsyncADKStore.get_events 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) analyze (sqlspec.builder.SQLFactory.explain parameter) (sqlspec.core.statement.SQL.explain parameter) any() (sqlspec.builder.SQLFactory static method) any_ (sqlspec.builder.SQLFactory property) app_config (sqlspec.extensions.litestar.SQLSpecPlugin.on_app_init parameter), [1] app_name (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.list_sessions parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.list_sessions parameter) (sqlspec.extensions.adk.memory.SQLSpecMemoryService.search_memory 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] arguments (sqlspec.core.stack.StackOperation attribute) arrow_schema (sqlspec.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) artifacts (sqlspec.driver.AsyncDriverAdapterBase.flush_staging_artifacts parameter) (sqlspec.driver.SyncDriverAdapterBase.flush_staging_artifacts parameter) as_script() (sqlspec.core.statement.SQL method) ast_transformer (sqlspec.core.parameters.ParameterStyleConfig attribute) AsyncDataDictionaryBase (class in sqlspec.driver) AsyncDriverAdapterBase (class in sqlspec.driver) author (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) avg() (sqlspec.builder.SQLFactory static method) avg_over() (sqlspec.builder.SQLFactory method) avg_over_ (sqlspec.builder.SQLFactory property) B batch_size (sqlspec.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) begin() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) build() (sqlspec.builder.Select method) builder() (sqlspec.core.statement.SQL method) bulk_insert() (sqlspec.builder.SQLFactory static method) C cache_stats() (sqlspec.core.parameters.ParameterProcessor method) (sqlspec.core.parameters.ParameterValidator method) cache_version() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) cache_version_for_driver() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) case() (sqlspec.builder.SQLFactory static method) case_ (sqlspec.builder.SQLFactory property) cast() (sqlspec.builder.SQLFactory static method) clear_cache() (sqlspec.core.parameters.ParameterProcessor method) (sqlspec.core.parameters.ParameterValidator 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.base.SQLSpec method) coalesce() (sqlspec.builder.SQLFactory static method) column (sqlspec.builder.SQLFactory.avg parameter) (sqlspec.builder.SQLFactory.avg_over parameter) (sqlspec.builder.SQLFactory.cast parameter) (sqlspec.builder.SQLFactory.count parameter) (sqlspec.builder.SQLFactory.count_distinct parameter) (sqlspec.builder.SQLFactory.count_over parameter) (sqlspec.builder.SQLFactory.decode parameter) (sqlspec.builder.SQLFactory.lag parameter) (sqlspec.builder.SQLFactory.lead parameter) (sqlspec.builder.SQLFactory.length parameter) (sqlspec.builder.SQLFactory.lower parameter) (sqlspec.builder.SQLFactory.max parameter) (sqlspec.builder.SQLFactory.max_over parameter) (sqlspec.builder.SQLFactory.min parameter) (sqlspec.builder.SQLFactory.min_over parameter) (sqlspec.builder.SQLFactory.nvl parameter) (sqlspec.builder.SQLFactory.nvl2 parameter) (sqlspec.builder.SQLFactory.round parameter) (sqlspec.builder.SQLFactory.sum parameter) (sqlspec.builder.SQLFactory.sum_over parameter) (sqlspec.builder.SQLFactory.upper parameter) (sqlspec.core.statement.SQL.where_between parameter) (sqlspec.core.statement.SQL.where_eq parameter) (sqlspec.core.statement.SQL.where_gt parameter) (sqlspec.core.statement.SQL.where_gte parameter) (sqlspec.core.statement.SQL.where_ilike parameter) (sqlspec.core.statement.SQL.where_in parameter) (sqlspec.core.statement.SQL.where_is_not_null parameter) (sqlspec.core.statement.SQL.where_is_null parameter) (sqlspec.core.statement.SQL.where_like parameter) (sqlspec.core.statement.SQL.where_lt parameter) (sqlspec.core.statement.SQL.where_lte parameter) (sqlspec.core.statement.SQL.where_neq parameter) (sqlspec.core.statement.SQL.where_not_in 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) comment_on() (sqlspec.builder.SQLFactory method) commit() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) compile() (sqlspec.core.statement.SQL method) concat() (sqlspec.builder.SQLFactory static method) condition (sqlspec.core.statement.SQL.where parameter) config (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore parameter), [1] (sqlspec.base.SQLSpec.add_config parameter) (sqlspec.base.SQLSpec.close_pool parameter) (sqlspec.base.SQLSpec.event_channel parameter) (sqlspec.base.SQLSpec.get_connection parameter) (sqlspec.base.SQLSpec.get_pool parameter) (sqlspec.base.SQLSpec.get_session parameter) (sqlspec.base.SQLSpec.provide_connection parameter) (sqlspec.base.SQLSpec.provide_session parameter) (sqlspec.base.SQLSpec.update_cache_config parameter) (sqlspec.core.parameters.ParameterProcessor.process_for_execution parameter) (sqlspec.extensions.adk.BaseAsyncADKMemoryStore parameter), [1] (sqlspec.extensions.adk.BaseAsyncADKStore parameter), [1] (sqlspec.extensions.adk.BaseSyncADKMemoryStore parameter), [1] (sqlspec.extensions.adk.BaseSyncADKStore parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService.get_session parameter), [1] configs (sqlspec.base.SQLSpec property) configure_cache() (sqlspec.base.SQLSpec static method) connection (sqlspec.driver.AsyncDriverAdapterBase.dispatch_statement_execution parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_statement_execution parameter) content (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) convert_placeholder_style() (sqlspec.core.parameters.ParameterConverter method) convert_to_dialect() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase 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) count_over() (sqlspec.builder.SQLFactory method) count_over_ (sqlspec.builder.SQLFactory property) count_with_window (sqlspec.driver.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver.SyncDriverAdapterBase.select_with_total parameter) create_index() (sqlspec.builder.SQLFactory method) create_materialized_view() (sqlspec.builder.SQLFactory method) create_schema() (sqlspec.builder.SQLFactory method) create_table() (sqlspec.builder.SQLFactory method) create_table_as_select() (sqlspec.builder.SQLFactory method) 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 (sqlspec.driver.AsyncDriverAdapterBase.dispatch_execute parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_execute_many parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_execute_script parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_special_handling parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_execute parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_execute_many parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_execute_script parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_special_handling parameter) D data (sqlspec.core.result.SQLResult parameter) data_dictionary (sqlspec.driver.AsyncDriverAdapterBase property) (sqlspec.driver.SyncDriverAdapterBase property) data_type (sqlspec.builder.SQLFactory.cast parameter) DataDictionaryMixin (class in sqlspec.driver) days (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.delete_entries_older_than parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.delete_entries_older_than parameter) decimals (sqlspec.builder.SQLFactory.round parameter) decode() (sqlspec.builder.SQLFactory static method) default (sqlspec.builder.SQLFactory.lag parameter) (sqlspec.builder.SQLFactory.lead parameter) (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() (sqlspec.builder.SQLFactory method) dense_rank() (sqlspec.builder.SQLFactory method) dense_rank_ (sqlspec.builder.SQLFactory property) desc (sqlspec.core.statement.SQL.order_by parameter) destination (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) detail (sqlspec.exceptions.StackExecutionError parameter) detect_sql_type() (sqlspec.builder.SQLFactory class method) detect_version_with_queries() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) dialect (sqlspec.base.SQLSpec.add_named_sql 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_materialized_view parameter) (sqlspec.builder.SQLFactory.drop_schema parameter) (sqlspec.builder.SQLFactory.drop_table parameter) (sqlspec.builder.SQLFactory.drop_view parameter) (sqlspec.builder.SQLFactory.explain parameter) (sqlspec.builder.SQLFactory.rename_table parameter) (sqlspec.builder.SQLFactory.upsert parameter) (sqlspec.core.parameters.ParameterProcessor.process_for_execution parameter) (sqlspec.core.statement.SQL property) (sqlspec.core.statement.SQL.builder parameter) (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) (sqlspec.driver.AsyncDataDictionaryBase attribute) (sqlspec.driver.AsyncDriverAdapterBase attribute) (sqlspec.driver.SyncDataDictionaryBase attribute) (sqlspec.driver.SyncDriverAdapterBase attribute) dispatch_execute() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) dispatch_execute_many() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) dispatch_execute_script() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) dispatch_special_handling() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) dispatch_statement_execution() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) distinct (sqlspec.builder.SQLFactory.count parameter) (sqlspec.builder.SQLFactory.sum parameter) driver (sqlspec.driver.AsyncDataDictionaryBase.cache_version_for_driver parameter) (sqlspec.driver.AsyncDataDictionaryBase.detect_version_with_queries parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_cached_version_for_driver parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_columns parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_feature_flag parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_foreign_keys parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_indexes parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_optimal_type parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_tables parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_version parameter) (sqlspec.driver.DataDictionaryMixin.cache_version_for_driver parameter) (sqlspec.driver.DataDictionaryMixin.detect_version_with_queries parameter) (sqlspec.driver.DataDictionaryMixin.get_cached_version_for_driver parameter) (sqlspec.driver.SyncDataDictionaryBase.cache_version_for_driver parameter) (sqlspec.driver.SyncDataDictionaryBase.detect_version_with_queries parameter) (sqlspec.driver.SyncDataDictionaryBase.get_cached_version_for_driver parameter) (sqlspec.driver.SyncDataDictionaryBase.get_columns parameter) (sqlspec.driver.SyncDataDictionaryBase.get_feature_flag parameter) (sqlspec.driver.SyncDataDictionaryBase.get_foreign_keys parameter) (sqlspec.driver.SyncDataDictionaryBase.get_indexes parameter) (sqlspec.driver.SyncDataDictionaryBase.get_optimal_type parameter) (sqlspec.driver.SyncDataDictionaryBase.get_tables parameter) (sqlspec.driver.SyncDataDictionaryBase.get_version parameter) driver_id (sqlspec.driver.AsyncDataDictionaryBase.cache_version parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_cached_version parameter) (sqlspec.driver.DataDictionaryMixin.cache_version parameter) (sqlspec.driver.DataDictionaryMixin.get_cached_version parameter) (sqlspec.driver.SyncDataDictionaryBase.cache_version parameter) (sqlspec.driver.SyncDataDictionaryBase.get_cached_version parameter) drop_index() (sqlspec.builder.SQLFactory method) drop_materialized_view() (sqlspec.builder.SQLFactory method) drop_schema() (sqlspec.builder.SQLFactory method) drop_table() (sqlspec.builder.SQLFactory method) drop_view() (sqlspec.builder.SQLFactory method) 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_column_pruning (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) entries (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.insert_memory_entries parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.insert_memory_entries parameter) error (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.StackResult attribute) (sqlspec.driver.AsyncDriverAdapterBase.flush_staging_artifacts parameter) (sqlspec.driver.SyncDriverAdapterBase.flush_staging_artifacts parameter) errors (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) event (sqlspec.extensions.adk.SQLSpecSessionService.append_event parameter), [1] event_channel() (sqlspec.base.SQLSpec method) event_id (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) event_record (sqlspec.extensions.adk.BaseAsyncADKStore.append_event parameter) execute() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) execute_many() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) execute_script() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) execute_stack() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) 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_time (sqlspec.core.result.SQLResult parameter) exists_ (sqlspec.builder.SQLFactory property) expires_in (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.set parameter) explain() (sqlspec.builder.SQLFactory method) (sqlspec.core.statement.SQL method) expression (sqlspec.core.statement.SQL property) extend() (sqlspec.core.stack.StatementStack method) extract_parameters() (sqlspec.core.parameters.ParameterValidator method) F feature (sqlspec.driver.AsyncDataDictionaryBase.get_feature_flag parameter) (sqlspec.driver.SyncDataDictionaryBase.get_feature_flag parameter) FeatureFlags (class in sqlspec.data_dictionary) FeatureVersions (class in sqlspec.data_dictionary) fetch() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) fetch_one() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) fetch_one_or_none() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) fetch_to_arrow() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) fetch_value() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) fetch_value_or_none() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) fetch_with_total() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) file_format (sqlspec.driver.AsyncDriverAdapterBase.load_from_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_storage parameter) filters (sqlspec.core.statement.SQL property) flush_staging_artifacts() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase 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) foreign_keys (sqlspec.driver.AsyncDataDictionaryBase.sort_tables_topologically parameter) (sqlspec.driver.DataDictionaryMixin.sort_tables_topologically parameter) (sqlspec.driver.SyncDataDictionaryBase.sort_tables_topologically parameter) format (sqlspec.builder.SQLFactory.explain parameter) (sqlspec.core.statement.SQL.explain parameter) format_hint (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) fragment_cache_enabled (sqlspec.base.SQLSpec.configure_cache parameter) fragment_cache_size (sqlspec.base.SQLSpec.configure_cache parameter) freeze() (sqlspec.core.statement.StatementConfig method) 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_affected_count() (sqlspec.core.result.SQLResult method) get_cache_config() (sqlspec.base.SQLSpec static method) get_cache_stats() (sqlspec.base.SQLSpec static method) get_cached_version() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) get_cached_version_for_driver() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) get_columns() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_connection() (sqlspec.base.SQLSpec method) get_count() (sqlspec.core.result.SQLResult method) get_data() (sqlspec.core.result.SQLResult method) get_default_features() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) get_default_type_mapping() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) get_dialect_config() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_feature_flag() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_filters_view() (sqlspec.core.statement.SQL method) get_first() (sqlspec.core.result.SQLResult method) get_foreign_keys() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_indexes() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_metadata() (sqlspec.core.result.SQLResult method) get_optimal_type() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_pool() (sqlspec.base.SQLSpec method) get_processed_state() (sqlspec.core.statement.SQL method) get_query() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_query_text() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_query_text_or_none() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_result() (sqlspec.core.result.StackResult method) get_session() (sqlspec.base.SQLSpec method) get_sql() (sqlspec.base.SQLSpec method) get_sql_files() (sqlspec.base.SQLSpec method) get_storage_job() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) get_tables() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) get_total_rows_affected() (sqlspec.core.result.SQLResult method) get_version() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) grouping_sets() (sqlspec.builder.SQLFactory static method) H handle_database_exceptions() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) 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_sql_query() (sqlspec.base.SQLSpec method) hash() (sqlspec.core.parameters.ParameterStyleConfig method) high (sqlspec.core.statement.SQL.where_between parameter) hint (sqlspec.builder.Select.with_hint parameter) I in_ (sqlspec.builder.SQLFactory property) index (sqlspec.core.result.SQLResult.__getitem__ parameter) index_name (sqlspec.builder.SQLFactory.create_index parameter) (sqlspec.builder.SQLFactory.drop_index parameter) inner_join_ (sqlspec.builder.SQLFactory property) insert() (sqlspec.builder.SQLFactory method) inserted_ids (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) is_arrow_result() (sqlspec.core.result.StackResult method) is_async (sqlspec.driver.AsyncDriverAdapterBase property) is_empty() (sqlspec.core.result.SQLResult method) is_error() (sqlspec.core.result.StackResult method) is_many (sqlspec.core.parameters.ParameterProcessor.process_for_execution parameter) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL property) is_modifying_operation() (sqlspec.core.statement.SQL method) is_processed (sqlspec.core.statement.SQL property) is_script (sqlspec.core.statement.SQL property) is_sql_result() (sqlspec.core.result.StackResult method) is_success() (sqlspec.core.result.SQLResult method) J job_id (sqlspec.driver.AsyncDriverAdapterBase.get_storage_job parameter) (sqlspec.driver.SyncDriverAdapterBase.get_storage_job 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.core.result.SQLResult.get_metadata parameter) (sqlspec.core.result.SQLResult.set_metadata parameter) (sqlspec.extensions.litestar.SQLSpecPlugin.get_annotation parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection_async parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection_sync parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session_async parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session_sync parameter), [1] keyword_arguments (sqlspec.core.stack.StackOperation attribute) L lag() (sqlspec.builder.SQLFactory method) lag_ (sqlspec.builder.SQLFactory property) last_inserted_id (sqlspec.core.result.SQLResult parameter) lateral_join_ (sqlspec.builder.SQLFactory property) lead() (sqlspec.builder.SQLFactory method) lead_ (sqlspec.builder.SQLFactory property) left_join_ (sqlspec.builder.SQLFactory property) left_lateral_join_ (sqlspec.builder.SQLFactory property) length() (sqlspec.builder.SQLFactory static method) limit (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.get_events parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.search_entries parameter) limit() (sqlspec.core.statement.SQL method) list_available_features() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) list_sql_queries() (sqlspec.base.SQLSpec method) load_from_arrow() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) load_from_storage() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase 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) low (sqlspec.core.statement.SQL.where_between parameter) lower() (sqlspec.builder.SQLFactory static method) M max() (sqlspec.builder.SQLFactory static method) max_over() (sqlspec.builder.SQLFactory method) max_over_ (sqlspec.builder.SQLFactory property) 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) min() (sqlspec.builder.SQLFactory static method) min_over() (sqlspec.builder.SQLFactory method) min_over_ (sqlspec.builder.SQLFactory property) N name (sqlspec.base.SQLSpec.add_named_sql parameter) (sqlspec.base.SQLSpec.get_sql parameter) (sqlspec.base.SQLSpec.has_sql_query 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] 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.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) needs_static_script_compilation (sqlspec.core.parameters.ParameterStyleConfig attribute) NONE (sqlspec.core.parameters.ParameterStyle attribute) 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 of (sqlspec.builder.Select.for_share parameter) (sqlspec.builder.Select.for_update parameter) offset (sqlspec.builder.SQLFactory.lag parameter) (sqlspec.builder.SQLFactory.lead parameter) offset() (sqlspec.core.statement.SQL method) old_name (sqlspec.builder.SQLFactory.rename_table parameter) 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_type (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.SQLResult property) (sqlspec.core.statement.SQL property) operations (sqlspec.core.stack.StatementStack property) optimized_cache_enabled (sqlspec.base.SQLSpec.configure_cache parameter) optimized_cache_size (sqlspec.base.SQLSpec.configure_cache parameter) order_by (sqlspec.builder.SQLFactory.avg_over parameter) (sqlspec.builder.SQLFactory.dense_rank parameter) (sqlspec.builder.SQLFactory.lag parameter) (sqlspec.builder.SQLFactory.lead parameter) (sqlspec.builder.SQLFactory.max_over parameter) (sqlspec.builder.SQLFactory.min_over parameter) (sqlspec.builder.SQLFactory.rank parameter) (sqlspec.builder.SQLFactory.row_number parameter) (sqlspec.builder.SQLFactory.sum_over parameter) order_by() (sqlspec.core.statement.SQL method) original_parameters (sqlspec.core.statement.SQL property) output_transformer (sqlspec.core.parameters.ParameterStyleConfig attribute) (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) overwrite (sqlspec.driver.AsyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.load_from_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_storage parameter) owner_id (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.insert_memory_entries parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.insert_memory_entries parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter) P page (sqlspec.core.statement.SQL.paginate parameter) page_size (sqlspec.core.statement.SQL.paginate parameter) paginate() (sqlspec.core.statement.SQL method) param_fingerprint (sqlspec.core.parameters.ParameterProcessor.process_for_execution 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_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.core.parameters.ParameterProcessor.process_for_execution parameter) (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.statement.SQL property) (sqlspec.core.statement.SQL.copy parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) ParameterStyle (class in sqlspec.core.parameters) ParameterStyleConfig (class in sqlspec.core.parameters) ParameterValidator (class in sqlspec.core.parameters) parse_version_string() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) parse_version_with_pattern() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) parsed_expression (sqlspec.core.parameters.ParameterProcessor.process_for_execution parameter) partition_by (sqlspec.builder.SQLFactory.avg_over parameter) (sqlspec.builder.SQLFactory.count_over parameter) (sqlspec.builder.SQLFactory.dense_rank parameter) (sqlspec.builder.SQLFactory.lag parameter) (sqlspec.builder.SQLFactory.lead parameter) (sqlspec.builder.SQLFactory.max_over parameter) (sqlspec.builder.SQLFactory.min_over parameter) (sqlspec.builder.SQLFactory.rank parameter) (sqlspec.builder.SQLFactory.row_number parameter) (sqlspec.builder.SQLFactory.sum_over parameter) partitioner (sqlspec.driver.AsyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.load_from_storage parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) pattern (sqlspec.core.statement.SQL.where_ilike parameter) (sqlspec.core.statement.SQL.where_like parameter) (sqlspec.driver.AsyncDataDictionaryBase.parse_version_with_pattern parameter) (sqlspec.driver.DataDictionaryMixin.parse_version_with_pattern parameter) (sqlspec.driver.SyncDataDictionaryBase.parse_version_with_pattern parameter) placeholder_style (sqlspec.builder.SQLFactory.bulk_insert parameter) POSITIONAL_COLON (sqlspec.core.parameters.ParameterStyle attribute) positional_parameters (sqlspec.core.statement.SQL property) POSITIONAL_PYFORMAT (sqlspec.core.parameters.ParameterStyle attribute) preserve_original_params_for_many (sqlspec.core.parameters.ParameterStyleConfig attribute) preserve_parameter_format (sqlspec.core.parameters.ParameterStyleConfig attribute) pretty (sqlspec.driver.AsyncDriverAdapterBase.convert_to_dialect parameter) (sqlspec.driver.SyncDriverAdapterBase.convert_to_dialect parameter) process() (sqlspec.core.parameters.ParameterProcessor method) process_for_execution() (sqlspec.core.parameters.ParameterProcessor method) provide_connection() (sqlspec.base.SQLSpec method) provide_session() (sqlspec.base.SQLSpec method) prune_columns (sqlspec.core.statement.SQL.select_only parameter) 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) Q QMARK (sqlspec.core.parameters.ParameterStyle attribute) queries (sqlspec.driver.AsyncDataDictionaryBase.detect_version_with_queries parameter) (sqlspec.driver.DataDictionaryMixin.detect_version_with_queries parameter) (sqlspec.driver.SyncDataDictionaryBase.detect_version_with_queries parameter) query (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.memory.SQLSpecMemoryService.search_memory parameter) R rank() (sqlspec.builder.SQLFactory method) rank_ (sqlspec.builder.SQLFactory property) raw() (sqlspec.builder.SQLFactory static method) raw_data (sqlspec.core.result.SQLResult property) raw_expression (sqlspec.core.statement.SQL property) raw_sql (sqlspec.core.statement.SQL property) reload_sql_files() (sqlspec.base.SQLSpec method) rename_table() (sqlspec.builder.SQLFactory method) renew_for (sqlspec.adapters.aiosqlite.litestar.AiosqliteStore.get parameter) replace() (sqlspec.core.parameters.ParameterStyleConfig method) (sqlspec.core.statement.StatementConfig method) request (sqlspec.driver.AsyncDriverAdapterBase.stage_artifact parameter) (sqlspec.driver.SyncDriverAdapterBase.stage_artifact parameter) reset() (sqlspec.core.statement.SQL method) reset_cache_stats() (sqlspec.base.SQLSpec static method) resolve_feature_flag() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase method) resolve_schema() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.SyncDataDictionaryBase 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.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) returns_rows() (sqlspec.core.statement.SQL method) right_join_ (sqlspec.builder.SQLFactory property) rollback() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) rollup() (sqlspec.builder.SQLFactory static method) round() (sqlspec.builder.SQLFactory static method) row_format (sqlspec.core.result.SQLResult parameter) row_number() (sqlspec.builder.SQLFactory method) row_number_ (sqlspec.builder.SQLFactory property) rows_affected (sqlspec.core.result.SQLResult parameter) (sqlspec.core.result.StackResult attribute) S scalar() (sqlspec.core.result.SQLResult method) scalar_or_none() (sqlspec.core.result.SQLResult method) schema (sqlspec.driver.AsyncDataDictionaryBase.get_columns parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_foreign_keys parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_indexes parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_tables parameter) (sqlspec.driver.SyncDataDictionaryBase.get_columns parameter) (sqlspec.driver.SyncDataDictionaryBase.get_foreign_keys parameter) (sqlspec.driver.SyncDataDictionaryBase.get_indexes parameter) (sqlspec.driver.SyncDataDictionaryBase.get_tables parameter) 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.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver.SyncDriverAdapterBase.select_with_total parameter) scope (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection_async parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection_sync parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session_async parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session_sync parameter), [1] Select (class in sqlspec.builder) select() (sqlspec.builder.SQLFactory method) (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_one() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_one_or_none() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_only() (sqlspec.core.statement.SQL method) select_to_arrow() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_to_storage() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_value() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_value_or_none() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) select_with_total() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) session (sqlspec.extensions.adk.memory.SQLSpecMemoryService.add_session_to_memory parameter) (sqlspec.extensions.adk.SQLSpecSessionService.append_event parameter), [1] session_id (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.delete_entries_by_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.delete_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.get_events parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.get_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.update_session_state parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.delete_entries_by_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.delete_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.get_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.list_events parameter) (sqlspec.extensions.adk.BaseSyncADKStore.update_session_state 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] set_cache_max_size() (sqlspec.core.parameters.ParameterValidator method) set_metadata() (sqlspec.core.result.SQLResult method) skip_locked (sqlspec.builder.Select.for_share parameter) (sqlspec.builder.Select.for_update parameter) sort_tables_topologically() (sqlspec.driver.AsyncDataDictionaryBase method) (sqlspec.driver.DataDictionaryMixin method) (sqlspec.driver.SyncDataDictionaryBase method) source (sqlspec.driver.AsyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.load_from_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_storage parameter) SQL (class in sqlspec.core.statement) sql (sqlspec.base.SQLSpec.add_named_sql parameter) (sqlspec.core.parameters.ParameterProcessor.process_for_execution parameter) (sqlspec.core.statement.SQL property) sql_cache_enabled (sqlspec.base.SQLSpec.configure_cache parameter) sql_cache_size (sqlspec.base.SQLSpec.configure_cache parameter) sql_fragment (sqlspec.builder.SQLFactory.raw parameter) SQLFactory (class in sqlspec.builder) SQLResult (class in sqlspec.core.result) SQLSpec (class in sqlspec.base) sqlspec (sqlspec.extensions.litestar.SQLSpecPlugin parameter), [1] StackExecutionError (class in sqlspec.exceptions) StackOperation (class in sqlspec.core.stack) StackResult (class in sqlspec.core.result) stage_artifact() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) state (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.update_session_state parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.update_session_state parameter) (sqlspec.extensions.adk.SQLSpecSessionService.create_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection_async parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_connection_sync parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session_async parameter), [1] (sqlspec.extensions.litestar.SQLSpecPlugin.provide_request_session_sync parameter), [1] statement (sqlspec.builder.SQLFactory.__call__ parameter) (sqlspec.builder.SQLFactory.explain parameter) (sqlspec.core.result.SQLResult parameter) (sqlspec.core.stack.StackOperation attribute) (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL.copy parameter) (sqlspec.driver.AsyncDriverAdapterBase.convert_to_dialect parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_execute parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_execute_many parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_execute_script parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_special_handling parameter) (sqlspec.driver.AsyncDriverAdapterBase.dispatch_statement_execution parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver.SyncDriverAdapterBase.convert_to_dialect parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_execute parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_execute_many parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_execute_script parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_special_handling parameter) (sqlspec.driver.SyncDriverAdapterBase.dispatch_statement_execution parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.SyncDriverAdapterBase.select_with_total parameter) statement_config (sqlspec.core.statement.SQL parameter) (sqlspec.core.statement.SQL property) (sqlspec.driver.AsyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_with_total parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.SyncDriverAdapterBase.select_with_total parameter) statement_expression (sqlspec.core.statement.SQL property) statement_results (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) statement_transformers (sqlspec.core.statement.StatementConfig attribute) (sqlspec.core.statement.StatementConfig parameter) StatementConfig (class in sqlspec.core.statement) StatementStack (class in sqlspec.core.stack) STATIC (sqlspec.core.parameters.ParameterStyle attribute) store (sqlspec.extensions.adk.memory.SQLSpecMemoryService parameter), [1] (sqlspec.extensions.adk.SQLSpecSessionService parameter), [1], [2], [3] strict_named_parameters (sqlspec.core.parameters.ParameterStyleConfig attribute) substitute_value (sqlspec.builder.SQLFactory.nvl parameter) successful_statements (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) sum() (sqlspec.builder.SQLFactory static method) sum_over() (sqlspec.builder.SQLFactory method) sum_over_ (sqlspec.builder.SQLFactory property) supported_execution_parameter_styles (sqlspec.core.parameters.ParameterStyleConfig attribute) supported_parameter_styles (sqlspec.core.parameters.ParameterStyleConfig attribute) supports_arrays (sqlspec.data_dictionary.FeatureFlags attribute) supports_clustering (sqlspec.data_dictionary.FeatureFlags attribute) supports_cte (sqlspec.data_dictionary.FeatureFlags attribute) (sqlspec.data_dictionary.FeatureVersions attribute) supports_generators (sqlspec.data_dictionary.FeatureFlags attribute) supports_geography (sqlspec.data_dictionary.FeatureFlags attribute) supports_in_memory (sqlspec.data_dictionary.FeatureFlags attribute) supports_index_clustering (sqlspec.data_dictionary.FeatureFlags attribute) supports_interleaved_tables (sqlspec.data_dictionary.FeatureFlags attribute) supports_json (sqlspec.data_dictionary.FeatureFlags attribute) (sqlspec.data_dictionary.FeatureVersions attribute) supports_jsonb (sqlspec.data_dictionary.FeatureVersions attribute) supports_maps (sqlspec.data_dictionary.FeatureFlags attribute) supports_partitioning (sqlspec.data_dictionary.FeatureFlags attribute) (sqlspec.data_dictionary.FeatureVersions attribute) supports_prepared_statements (sqlspec.data_dictionary.FeatureFlags attribute) supports_returning (sqlspec.data_dictionary.FeatureFlags attribute) (sqlspec.data_dictionary.FeatureVersions attribute) supports_schemas (sqlspec.data_dictionary.FeatureFlags attribute) supports_structs (sqlspec.data_dictionary.FeatureFlags attribute) supports_transactions (sqlspec.data_dictionary.FeatureFlags attribute) supports_upsert (sqlspec.data_dictionary.FeatureFlags attribute) (sqlspec.data_dictionary.FeatureVersions attribute) supports_uuid (sqlspec.data_dictionary.FeatureFlags attribute) supports_window_functions (sqlspec.data_dictionary.FeatureFlags attribute) (sqlspec.data_dictionary.FeatureVersions attribute) SyncDataDictionaryBase (class in sqlspec.driver) SyncDriverAdapterBase (class in sqlspec.driver) T table (sqlspec.builder.Select.with_hint parameter) (sqlspec.builder.SQLFactory.column parameter) (sqlspec.builder.SQLFactory.upsert parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_columns parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_foreign_keys parameter) (sqlspec.driver.AsyncDataDictionaryBase.get_indexes parameter) (sqlspec.driver.AsyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.AsyncDriverAdapterBase.load_from_storage parameter) (sqlspec.driver.SyncDataDictionaryBase.get_columns parameter) (sqlspec.driver.SyncDataDictionaryBase.get_foreign_keys parameter) (sqlspec.driver.SyncDataDictionaryBase.get_indexes parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_arrow parameter) (sqlspec.driver.SyncDriverAdapterBase.load_from_storage 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) tables (sqlspec.driver.AsyncDataDictionaryBase.sort_tables_topologically parameter) (sqlspec.driver.DataDictionaryMixin.sort_tables_topologically parameter) (sqlspec.driver.SyncDataDictionaryBase.sort_tables_topologically parameter) telemetry (sqlspec.driver.AsyncDriverAdapterBase.select_to_storage parameter) (sqlspec.driver.SyncDriverAdapterBase.select_to_storage parameter) telemetry_snapshot() (sqlspec.base.SQLSpec method) to_arrow() (sqlspec.core.result.SQLResult method) to_dialect (sqlspec.driver.AsyncDriverAdapterBase.convert_to_dialect parameter) (sqlspec.driver.SyncDriverAdapterBase.convert_to_dialect parameter) to_literal() (sqlspec.builder.SQLFactory static method) to_pandas() (sqlspec.core.result.SQLResult method) to_polars() (sqlspec.core.result.SQLResult method) total_count (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) total_statements (sqlspec.core.result.SQLResult attribute) (sqlspec.core.result.SQLResult parameter) truncate() (sqlspec.builder.SQLFactory method) type_category (sqlspec.driver.AsyncDataDictionaryBase.get_optimal_type parameter) (sqlspec.driver.SyncDataDictionaryBase.get_optimal_type parameter) type_coercion_map (sqlspec.core.parameters.ParameterStyleConfig attribute) U update() (sqlspec.builder.SQLFactory method) update_cache_config() (sqlspec.base.SQLSpec static method) upper() (sqlspec.builder.SQLFactory static method) upsert() (sqlspec.builder.SQLFactory method) user_id (sqlspec.extensions.adk.BaseAsyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseAsyncADKStore.list_sessions parameter) (sqlspec.extensions.adk.BaseSyncADKMemoryStore.search_entries parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_event parameter) (sqlspec.extensions.adk.BaseSyncADKStore.create_session parameter) (sqlspec.extensions.adk.BaseSyncADKStore.list_sessions parameter) (sqlspec.extensions.adk.memory.SQLSpecMemoryService.search_memory 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.builder.SQLFactory.to_literal parameter) (sqlspec.core.result.SQLResult.set_metadata parameter) (sqlspec.core.statement.SQL.add_named_parameter parameter) (sqlspec.core.statement.SQL.limit parameter) (sqlspec.core.statement.SQL.offset parameter) (sqlspec.core.statement.SQL.where_eq parameter) (sqlspec.core.statement.SQL.where_gt parameter) (sqlspec.core.statement.SQL.where_gte parameter) (sqlspec.core.statement.SQL.where_lt parameter) (sqlspec.core.statement.SQL.where_lte parameter) (sqlspec.core.statement.SQL.where_neq parameter) value_if_not_null (sqlspec.builder.SQLFactory.nvl2 parameter) value_if_null (sqlspec.builder.SQLFactory.nvl2 parameter) value_type (sqlspec.driver.AsyncDriverAdapterBase.select_value parameter) (sqlspec.driver.AsyncDriverAdapterBase.select_value_or_none parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value parameter) (sqlspec.driver.SyncDriverAdapterBase.select_value_or_none parameter) values (sqlspec.builder.SQLFactory.any parameter) (sqlspec.builder.SQLFactory.not_any_ parameter) (sqlspec.core.statement.SQL.where_in parameter) (sqlspec.core.statement.SQL.where_not_in parameter) verbose (sqlspec.builder.SQLFactory.explain parameter) (sqlspec.core.statement.SQL.explain parameter) version (sqlspec.driver.AsyncDataDictionaryBase.cache_version parameter) (sqlspec.driver.AsyncDataDictionaryBase.cache_version_for_driver parameter) (sqlspec.driver.DataDictionaryMixin.cache_version parameter) (sqlspec.driver.DataDictionaryMixin.cache_version_for_driver parameter) (sqlspec.driver.SyncDataDictionaryBase.cache_version parameter) (sqlspec.driver.SyncDataDictionaryBase.cache_version_for_driver parameter) version_str (sqlspec.driver.AsyncDataDictionaryBase.parse_version_string parameter) (sqlspec.driver.AsyncDataDictionaryBase.parse_version_with_pattern parameter) (sqlspec.driver.DataDictionaryMixin.parse_version_string parameter) (sqlspec.driver.DataDictionaryMixin.parse_version_with_pattern parameter) (sqlspec.driver.SyncDataDictionaryBase.parse_version_string parameter) (sqlspec.driver.SyncDataDictionaryBase.parse_version_with_pattern parameter) view_name (sqlspec.builder.SQLFactory.create_materialized_view parameter) (sqlspec.builder.SQLFactory.create_view parameter) (sqlspec.builder.SQLFactory.drop_materialized_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) where_between() (sqlspec.core.statement.SQL method) where_eq() (sqlspec.core.statement.SQL method) where_gt() (sqlspec.core.statement.SQL method) where_gte() (sqlspec.core.statement.SQL method) where_ilike() (sqlspec.core.statement.SQL method) where_in() (sqlspec.core.statement.SQL method) where_is_not_null() (sqlspec.core.statement.SQL method) where_is_null() (sqlspec.core.statement.SQL method) where_like() (sqlspec.core.statement.SQL method) where_lt() (sqlspec.core.statement.SQL method) where_lte() (sqlspec.core.statement.SQL method) where_neq() (sqlspec.core.statement.SQL method) where_not_in() (sqlspec.core.statement.SQL method) with_cursor() (sqlspec.driver.AsyncDriverAdapterBase method) (sqlspec.driver.SyncDriverAdapterBase method) with_error() (sqlspec.core.result.StackResult method) with_hint() (sqlspec.builder.Select method) with_json_serializers() (sqlspec.core.parameters.ParameterStyleConfig method) wrap_types (sqlspec.core.parameters.ParameterProcessor.process_for_execution parameter) write_to_storage_async() (sqlspec.core.result.SQLResult method) write_to_storage_sync() (sqlspec.core.result.SQLResult method)
