Skip to content

Add comparators for system column types #157

@giant0791

Description

@giant0791

Add specialized comparators to enable equality checks for system type engines.
Examples:

# test for identity equality
expr = students.sys.database_id == '...'

# visibility test: explicit test for non deleted rows
stmt = select(students)
stmt.where(students.sys.is_deleted.is_(False) & students.c.grade > 2.0)

# temporal data
stmt = select(students)
stmt.where(
    students.sys.created_at.after("2024-12-31") 
    & students.sys.updated_at.before("2025-12-31")
)

Metadata

Metadata

Assignees

Labels

featureGroup together issues making up a full feature. It creates a parent-child relation with its issues.

Projects

Status

No status

Relationships

None yet

Development

No branches or pull requests

Issue actions