Welcome to csql’s documentation!

• Basic Usage
  • Example
  • Cool! But, how does it work?
  • Easy Parameters
  • Changing Parameter Values
  • csql
    • Q()
      • Q()
    • Parameters()
      • Parameters
        • Parameters.add()
    • Query
      • Query
        • Query.preview_pd()
        • Query.preview_pl()
        • Query.build()
        • Query.pd
        • Query.db
        • Query.pl
        • Query.ddb
        • Query.ch
        • Query.persist()
    • RenderedQuery
      • RenderedQuery
        • RenderedQuery.sql
        • RenderedQuery.parameters
        • RenderedQuery.parameter_names
        • RenderedQuery.pd
        • RenderedQuery.db
        • RenderedQuery.params_dict
        • RenderedQuery.ch
        • RenderedQuery.ddb
        • RenderedQuery.pl
    • Other
      • ParameterValue
      • ParameterPlaceholder
        • ParameterPlaceholder.fmt
    • ClickhouseQueryArgs
      • ClickhouseQueryArgs.query
      • ClickhouseQueryArgs.parameters
    • DuckDBQueryArgs
      • DuckDBQueryArgs.query
      • DuckDBQueryArgs.params
    • PolarsQueryArgs
      • PolarsQueryArgs.query
      • PolarsQueryArgs.execute_options
    • QueryBit
    • QueryExtension
• Controlling SQL Output
  • SQL Dialects
    • Inferred Dialects
    • DIY Dialects
  • csql.dialect
    • SQLDialect
    • ParamStyle
      • ParamStyle.numeric
      • ParamStyle.numeric_dollar
      • ParamStyle.qmark
      • ParamStyle.clickhouse
    • Limit
      • Limit.limit
      • Limit.top_n
      • Limit.ansi
    • InferOrDefault
      • InferOrDefault.dialect
    • DefaultDialect
    • Snowflake
    • DuckDB
    • MSSQL
  • Advanced Customization
    • Overrides
    • InferOrDefault
    • Parameter Rendering
    • csql.render.param
      • QMark
      • ColonNumeric
      • DollarNumeric
      • ParameterRenderer
        • ParameterRenderer._renderScalarSql()
      • SQL
      • AutoKey
        • AutoKey.k
    • Query Renderering
    • csql.render.query
      • BoringSQLRenderer
      • QueryRenderer
• Persistance / Caching
  • How it Works
  • csql.persist
    • Cacher
      • Cacher._persist()
    • Key
• csql.contrib
  • csql.contrib.persist
    • TempTableCacher
  • csql.contrib.persist.snowflake
    • SnowflakeResultSetCacher
  • csql.contrib.render
  • csql.contrib.render.param
    • UDFParameterRenderer
• Changelog
  • v0.12.0
    • New stuff:
  • v0.11.0
    • Breaking changes:
    • New stuff:
    • Deprecations:
  • v0.10.0
    • Breaking changes:
  • v0.9.0
    • Breaking changes:
    • New stuff:
    • Deprecations:
  • v0.8.0
  • v0.7.0
  • v0.6.0
  • v0.5.0
  • v0.4.0
  • v0.3.2
  • v0.3.1
  • v0.3.0

Indices and tables

• Index

• Module Index

• Search Page