Release notes#

PyStarburst 0.7.0 - February 21, 2024#

Features#

  • Add DataFrame.is_empty() method

  • Adds melt alias to unpivot

  • Add DataFrame.to() method

  • Add DataFrame.with_columns_renamed() and modified with_column_renamed accordingly

  • Add LambdaFunctionExpression

  • Add transform function

  • Add zip_with function

  • Added filter function

  • Added any_match function

  • Added all_match function

  • Added array_sort function

  • Added reduce function

  • Added transform_keys, transform_values functions

  • Added map_filter function

  • Added map_zip_with function

  • Support type coercion

  • Add json_array_length function

  • Add is_not_null function

  • Add to_json function

  • Support type coercion

  • Add from_json function

  • Add programmatic access to Starburst schema discovery feature, using discover method

  • Add get_json_object function

  • Add json_tuple function

Under the Hood#

  • Use EXECUTE IMMEDIATE for prepared statements by default

  • Allow up to 3 arguments for LambdaFunctionExpression

  • Give random names for lambda parameters

  • Add tests against Python 3.12

  • Lambda functions retain context

  • Remove source_plan from TrinoPlan

Dependencies#

  • Remove typing-extensions dependency

  • Remove backports-zoneinfo dependency

  • Remove testcontainers dependency

  • Update dependencies

  • Update trino to 0.327.0

PyStarburst 0.6.3 - November 09, 2023#

Under the Hood#

  • Conda release

PyStarburst 0.6.2 - October 18, 2023#

Features#

  • Add support for stack function

  • Implement to_pandas() method

  • Add map functions: create_map, map_from_arrays, map_keys, map_values, map_entries, map_from_entries, map_concat

  • Add array functions: reverse, flatten, sort_array, shuffle, sequence, array_prepend, array_compact, get

  • Add support for unpivot function

Fixes#

  • Fix to_timestamp to accept not only VARCHAR as an argument

Under the Hood#

  • PyPi release

PyStarburst 0.5.0 - August 17, 2023#

Features#

  • Add support for regexp_split

  • Add collect_list and collect_set

  • Add support for TIME WITH TIME ZONE

  • Implement array functions: array_distinct, array_min, array_max, array_union, array_except, array_slice, size, array_repeat, array_insert, array_join, array_remove, element_at, arrays_zip

  • Support for aggregate functions: max_by, min_by, product

  • Support tuple as struct

  • Support ilike column function

  • Support math functions