[MariaDB-connector] add support to query dynamic columns

[rponsaerts]

Hi,

Would it be possible to add support in the MariaDB connector to query dynamic columns in MariaDB?

https://mariadb.com/kb/en/dynamic-columns/

Currently, I don't see an easy way on how to do this.

best,

r

[findepi]

At first sight, accessing them as JSON (COLUMN_JSON(dynamic_cols)) looks most appropriate.

[rponsaerts]

There is a workaround, likely less powerful than directly querying MariaDB dynamic columns (VARBINARY in Trino) from Trino....

It is sometimes possible to create a useful MariaDB VIEW from the table that contains the dynamic columns and thereby converting the content in the dynamic columns to JSON or extracting JSON content from the dynamic columns. Using Trino JSON functions, further querying can be done on this JSON content within the MariaDB VIEW.

So, would be nice to put the enhancement on the MariaDB-connector development roadmap.