amsdal_glue_connections

v0.1.26 - 2026-06-15

Added

• Fixed-precision decimal support via DecimalSchemaModel: Postgres maps to NUMERIC(precision, scale) and SQLite to DECIMAL_TEXT(precision, scale).
• Decimal value type transform for Postgres (NUMERIC) and SQLite (DECIMAL_TEXT), with SQLite storing decimals as text to preserve precision.

Changed

• Postgres and SQLite type introspection now reconstructs DecimalSchemaModel (with precision/scale) when reading back NUMERIC / DECIMAL_TEXT columns instead of coercing them to float.

v0.1.25 - 2026-05-20

Added

• Exists subquery support across SQL, CSV, and Elasticsearch connections.
• JSONB array expression support for Postgres.
• Polars final query executor with negation-aware in-memory join and filter.
• Default projection handling in query builder.
• Nested subquery support in query builder.

Changed

• Improved query builder for subqueries and conditions.

Fixed

• CSV and Elasticsearch conditions safety (proper negation handling).
• Postgres value transform edge cases.

v0.1.24 - 2026-05-06

Changed

• Postgres and SQLite (sync + async) connections now raise UniqueViolationError on unique constraint violations.

Fixed

• Postgres regex / iregex lookups now use the correct ~ / ~* operators instead of the unsupported REGEXP syntax.

v0.1.23 - 2026-01-13

Fixed

• Fix for creating index in postgres

v0.1.22 - 2025-12-21

Changed

• Libs update

v0.1.21 - 2025-11-03

Fixed

• Fix for vector async operations

v0.1.20 - 2025-09-21

Fixed

• Fix for nested transactions in SQLite connection during schema migration

v0.1.19 - 2025-09-20

Changed

• Recreate table in sqlite on constraint changes

v0.1.18 - 2025-09-04

Fixed

• Fixed drop null in the postgres connection

v0.1.17 - 2025-09-03

Fixed

• Fix for foreign key regexp in SQLite

v0.1.16 - 2025-08-06

Added

• Elasticsearch connection

v0.1.15 - 2025-06-26

Added

• Added support for vector operations

v0.1.14 - 2025-06-17

Changed

• Update package manager to uv for better performance and compatibility.

v0.1.13 - 2025-06-10

Fixed

• Fixes for JSON in connections

v0.1.12 - 2025-06-09

Fixed

• Fix for SQLite table info retrieval

v0.1.11 - 2025-05-22

Fixed

• Fixed locking for async sqlite

v0.1.10 - 2025-05-19

Added

• Raise NOT NULL constraint failed for SQLite update column
• Added DEFAULT for column in sql builder

v0.1.9 - 2025-05-14

Changed

• Changes for tables retrieval

v0.1.8 - 2025-05-06

Fixed

• Fixed 'references' SQL

v0.1.7 - 2025-04-01

Fixed

• FK names in SQLite

v0.1.6 - 2025-03-18

Added

• Add csv as an optional dependency.

v0.1.5 - 2025-03-17

Added

• Support inline unique definition in SQLite

v0.1.4 - 2025-03-14

Changed

• Remove exception logs from connections

v0.1.3 - 2025-03-13

Fixed

• Adjustments for limit in CSV Connection

v0.1.2 - 2025-03-02

Added

• CSV Connection

v0.1.1 - 2025-02-25

Fixed

• Fixed ANY in postgresql

v0.1.0 - 2025-02-24

Changed

• Builder helpers
• Conditions

v0.0.21 - 2024-02-13

Fixes

• Disable locking in SQLite connection.

v0.0.20 - 2025-02-06

Added

• Postgres locking with SELECT FOR UPDATE.

v0.0.19 - 2024-12-18

Fixes

• Postgres is_alive check.

v0.0.18 - 2024-12-05

Added

• Postgres async connection.

v0.0.17 - 2024-11-14

Added

• Async connections support.

v0.0.16 - 2024-10-18

Changed

• Use 'JSONB' instead of 'JSON' in Postgres connections.

v0.0.15 - 2024-10-18

Fixed

• Error messages (error-messages)
• Postgres connection index retrieval (postgres-connection-index-retrieval)

v0.0.14 - 2024-10-15

Fixed

• Fixed postgres field update to DOUBLE PRECISION and BIGINT (postgres-field-update)

v0.0.13 - 2024-10-14

Added

• Nested types (nested-types)

v0.0.12 - 2024-09-16

Added

• Added ability to use math expressions in annotations. (math-expressions)

v0.0.11 - 2024-08-06

Added

• Documentation via docstrings (documentation)

Changed

• PostgresConnection: autocommit=True by default (autocommit-true)

v0.0.10 - 2024-08-02

Fixed

• Fixed dependencies (fixed-dependencies)

v0.0.9 - 2024-08-02

Added

• Typing added (typing-added)