Release 0.21.0

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog,
and this project adheres to Semantic Versioning.

0.21.0 (2026-01-03)

Feat

• enable Redshift nested element access tests (#140)
• add Redshift support for deeply nested complex types via SUPER (#139)
• add DuckDB support for deeply nested complex types (#138)
• add deeply nested complex types support for Athena and Trino (#136)

Fix

• use GET_ARRAY_LENGTH for Redshift SUPER type arrays

0.20.0 (2025-12-07)

Feat

• add BigQueryMockTable class for explicit three-part naming (#134)

0.19.0 (2025-12-07)

Feat

• reorganize documentation navigation for better learning flow
• comprehensive SEO optimization for better search visibility
• restrict CodeCov uploads to master branch only
• enable CodeCov carryforward for all coverage flags

Fix

• add support for Python 3.10+ pipe-none (X | None) union syntax (#133)
• sanitize CTE aliases and sync package version (#132)
• align robots.txt and sitemap with Google's official guidelines
• shorten page titles for better readability and display
• optimize robots.txt for better Google Search Console compatibility

0.18.0 (2025-12-01)

Feat

• add Google Analytics tracking
• improve SEO across PyPI, GitHub, and documentation

Fix

• update codecov-action parameter from 'file' to 'files'
• handle pytest-xdist environment in worker ID test
• shorten site title to prevent display issues
• update Twitter handle to @saran_gurmeet and remove non-existent image references

0.17.0 (2025-11-20)

Feat

• athena: add option to specify workgroup (#127)
• add CI code quality checks for all PRs (#129)

Fix

• correct workflow condition to allow push events after merge (#130)
• skip integration tests for fork PRs due to secret restrictions (#128)

0.16.0 (2025-08-20)

Feat

• upgrade mocksmith to 6.0.1 (#122)

Fix

• upgrade snowflake-connector-python to >=3.13.1 for critical security vulnerabilities (#123)

0.15.0 (2025-07-27)

Feat

• implement duckdb integration (#117)
• integrate mocksmith for test data generation and simplify relea… (#112)
• integrate mocksmith for test data generation and simplify release workflow

Fix

• added explicit dependency of faker
• upgrade mocksmith library version

0.14.0 (2025-06-30)

Feat

• bigquery: add struct support with list fields (#109)
• bigquery: add struct support for big query (#108)
• add parallel table cleanup for improved performance (#107)
• add parallel table creation for physical tables mode (#106)

Fix

• athena: handle mixed format structs with lists and maps (#111)

0.13.0 (2025-06-27)

Feat

• add pytest-xdist support for parallel test execution (#105)

Fix

• snowflake: fix issue related to physical view for snowflake (#104)

0.12.0 (2025-06-25)

Feat

• athena/trino: add support for struct/ROW types (#102)
• snowflake: add key-pair authentication for MFA support (#103)

0.11.0 (2025-06-16)

Feat

• snowflake: ad support for map datatype in snowflake (#101)

0.10.1 (2025-06-15)

Fix

• run unittests against different os/python versions (#100)

0.10.0 (2025-06-15)

Feat

• bigquery: add support for map in bigquery (#99)

0.9.0 (2025-06-10)

Feat

• redshift: add support for map datatype for redshift (#98)

0.8.0 (2025-06-09)

Feat

• athena/trino: add support for map data type for athena/trino (#96)

Refactor

• presto: move common code to presto base class (#97)

0.7.1 (2025-06-06)

Fix

• array: array handling logic + sql logging improvement (#95)

0.7.0 (2025-06-06)

Feat

• sqllogging: added support for logging sql logs for debugging failed tests (#94)

0.6.0 (2025-06-05)

Feat

• migrate from mypy to pyright for type checking (#86)

Perf

• athena: upgrade sqlglot package to get athena dialect (#88)

0.5.0 (2025-06-01)

BREAKING CHANGE

• SQLTestCase parameter execution_database renamed to default_namespace for clarity

Feat

• rename execution_database to default_namespace and standardize database context handling (#84)

0.4.0 (2025-05-31)

Feat

• implement lazy loading for heavy dependencies to improve import… (#82)
• add comprehensive GitHub issue templates (#80)
• parametrize integration tests and standardize SQL across adapters (#75)
• add comprehensive test coverage for core framework functionality (#68)
• enhance Codecov reporting and fix Redshift namespace deletion wait (#67)
• add comprehensive Pydantic model support for mock data (#66)
• add comprehensive array support and enhance Redshift security cleanup (#64)
• unify SQL string escaping and fix database-specific issues (#62)

Fix

• update all test imports after private module refactoring (#69)

0.3.0 (2025-05-26)

Feat

• add comprehensive Snowflake integration support (#61)
• add comprehensive Trino integration testing with Docker support

0.2.1 (2025-05-26)

Fix

• fix for change log generation

0.2.0 (2025-05-26)

Feat

• add comprehensive Redshift integration testing with Serverless support

Fix

• correct commitizen command syntax in release workflow
• update commitizen arguments in release workflow
• add explicit type casting for NULL values in Redshift adapter
• resolve Python version compatibility issues

0.1.3 (2025-05-25)

Fix

• allow triggering tests from release yaml file
• improvement in ci
• make release process manual

0.1.2 (2025-05-25)

Fix

• use personal access token for GitHub release creation

0.1.1 (2025-05-25)

Fix

• use pat to push release version
• release bump version was failing when there are no change

[0.1.0] - Initial Release

Added

• Core SQL testing framework with mock table injection
• Support for multiple database adapters:
  • BigQuery
  • Athena
  • Redshift
  • Snowflake
  • Trino
• Pytest plugin integration
• Comprehensive test suite
• Documentation and setup guides