0.5.11

New Features

• Timestamp.shift_tz() method: Shift a Timestamp value by a timezone offset. Accepts any datetime.tzinfo (including datetime.timezone and zoneinfo.ZoneInfo).

• Column.shift_tz() for queries: Shift an entire column of timestamps by a timezone offset within select() expressions.

2026-02-19 | 🔗 PyPI | 🔗 GitHub

0.5.10

Bug Fixes

• Various bugfixes to the database operations

2026-02-11 | 🔗 PyPI | 🔗 GitHub

0.5.9

Bug Fixes

• Fix boolean operator is_ performed over lists and vectors within table aggregations

2026-02-11 | 🔗 PyPI | 🔗 GitHub

0.5.8

Bug Fixes

• Fix type conversion error during upsert operation

2026-02-10 | 🔗 PyPI | 🔗 GitHub

0.5.7

Bug Fixes

• Fix boolean operator is_ performed over lists within table aggregations

2026-02-10 | 🔗 PyPI | 🔗 GitHub

0.5.6

Bug Fixes

• Fix sorting for symbol vectors larger than 32 elements

2026-01-29 | 🔗 PyPI | 🔗 GitHub

0.5.5

Breaking Changes

• SQLQuery API changed: SQLQuery now accepts a Table object instead of a table name string. Update calls from SQLQuery("table_name", query) to SQLQuery(Table("table_name"), query).

Bug Fixes

• Division operators fixed: Fixed __truediv__ (/) and __floordiv__ (//) being incorrectly swapped for scalars and vectors.
• Sorting MAPCOMMON columns: Fixed issue when tables containing MAPCOMMON columns were sorted incorrectly.

2026-01-28 | 🔗 PyPI | 🔗 GitHub

0.5.4

New Features

• SQL over IPC: Send SQL queries to remote Rayforce servers via TCP or WebSocket using the new SQLQuery class. Documentation

2026-01-17 | 🔗 PyPI | 🔗 GitHub

0.5.3

New Features

• SQL Query Support: Query tables using familiar SQL syntax with the new Table.sql() method. Supports SELECT, UPDATE, INSERT, and UPSERT (via ON CONFLICT) statements. Requires optional sqlglot dependency. See SQL documentation for details.

• Vector type inference: Vector now automatically infers the element type from the first item when ray_type is not specified.

2026-01-17 | 🔗 PyPI | 🔗 GitHub

0.5.2

New Features

• Vector operations: Added operations for Vector types including arithmetic (+, -, *, /), comparison (<, <=, >, >=, eq, ne), logical (and_, or_, not_), aggregation (sum, min, max, average), element access (first, last, take, at), set operations (union, sect, except_), search (find, within, filter), sort (asc, desc, iasc, rank, reverse, negate), and functional (map).

• Dict operations: Added key/value access (key, value) and sort operations (asc, desc) for Dict types.

• Scalar operations: Added arithmetic, comparison, and math operations (ceil, floor, round) for numeric scalar types (I16, I32, I64, F64).

2026-01-16 | 🔗 PyPI | 🔗 GitHub