Release v0.0.16

Release Notes for v0.0.16

Summary

This release focuses on PostgreSQL compatibility improvements, fixing critical syntax errors and adding comprehensive support for database object comments and CREATE INDEX operator classes.

New Features

• Complete PostgreSQL Comment System: Full implementation of COMMENT ON statements and comment functions

  • Added obj_description(oid, catalog_name) and col_description(table_oid, column_number) functions
  • Support for COMMENT ON TABLE, COMMENT ON COLUMN, and COMMENT ON FUNCTION statements
  • Schema migration v12 with __pgsqlite_comments table for persistent comment storage
  • Comprehensive PostgreSQL catalog compatibility for metadata queries

• CREATE INDEX Operator Class Support: PostgreSQL-compatible index creation syntax

  • Support for varchar_pattern_ops, text_pattern_ops, bpchar_pattern_ops operator classes
  • Automatic translation to SQLite COLLATE BINARY for pattern-optimized indexes
  • Multiple operator classes in single index statements
  • Full Django/SQLAlchemy migration compatibility

Bug Fixes

• Fixed "near varchar_pattern_ops: syntax error": CREATE INDEX statements with PostgreSQL operator classes now work correctly
• Fixed "no such function: obj_description": Catalog queries using PostgreSQL comment functions now execute without errors
• Improved test stability: Reduced concurrent reads test threshold for better CI reliability

Improvements

• Enhanced PostgreSQL Compatibility: Better support for standard PostgreSQL catalog queries and metadata operations
• Code Quality: Fixed multiple clippy warnings including manual_strip, if_same_then_else, and unnecessary_unwrap
• Test Coverage: Added comprehensive integration and unit tests for new comment system and index operator class features

Breaking Changes

None. This release maintains full backward compatibility while adding new PostgreSQL compatibility features.