Tracking: polars support

[jetjinser]

Polars is a DataFrame interface on top of an OLAP Query Engine implemented in Rust using Apache Arrow Columnar Format as the memory model.

Works normally with general use. However, when if_table_exist is specified as replace in the parameter of DataFrame.write_database, the sql query that risingwave currently does not support will be used.

• pg_sequence (not pg_sequences)
  • Tracking: System Table in pg_catalog #2954
  • bug: pg_sequence not found when write data with polars #15934
• json_build_object (not jsonb_build_object): https://www.postgresql.org/docs/16/functions-json.html#FUNCTIONS-JSON-CREATION-TABLE
  • Considering that RisingWave does not have a json datatype, this problem may need to be solved in other ways.

[neverchanje]

Related issue: risingwavelabs/sqlalchemy-risingwave#29
datapolars requires upgrading sqlalchemy version to v2.

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.