Releases: RayforceDB/rayforce-py
0.5.10
0.5.9
0.5.8
0.5.7
0.5.6
0.5.5
Breaking Changes
- SQLQuery API changed:
SQLQuerynow accepts aTableobject instead of a table name string. Update calls fromSQLQuery("table_name", query)toSQLQuery(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.
0.5.4
New Features
- SQL over IPC: Send SQL queries to remote Rayforce servers via TCP or WebSocket using the new
SQLQueryclass. Documentation
0.5.3
New Features
-
SQL Query Support: Query tables using familiar SQL syntax with the new
Table.sql()method. SupportsSELECT,UPDATE,INSERT, andUPSERT(viaON CONFLICT) statements. Requires optionalsqlglotdependency. See SQL documentation for details. -
Vector type inference:
Vectornow automatically infers the element type from the first item whenray_typeis not specified.
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).
0.5.1
New Features
pivot()method: Reshape data from long to wide format. Supports multiple index columns and aggregation functions (sum,count,avg,min,max,first,last). See Pivot documentation for details.