We are using Hibernate with Snowflake and need to do a Lateral Flatten: https://docs.snowflake.net/manuals/user-guide/json-basics-tutorial-flatten.html
We’re using CriteriaQueryBuilder to generate the query. How would I add table name, lateral flatten ie:
SELECT
col_a
FROM table agg_table
lateral flatten(input => agg_table.col_a)
group by 1;