machristie commented on issue #5: URL: https://github.com/apache/airavata-data-catalog/issues/5#issuecomment-1446458019
I've been investigating how to integrate Calcite to generate the kind of metadata schema queries that we want to support. However, I've run into a problem. Calcite doesn't support PostgreSQL JSON functions. And PostgreSQL doesn't yet support the standard JSON functions, see https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-sql-json-query-functions/ All in all, I think it's going to be a lot of work to try to get Calcite to work with PostgreSQL the way we want. I'm going to try working with just parsing and validating the query and then writing my own code to generate the PostgreSQL query from the parsed information. So the next step is to see if I can register the metadata schemas as virtual tables with Calcite so it can properly parse and validate user supplied queries. see also - https://issues.apache.org/jira/browse/CALCITE-4739 - [SQL language - JSON Functions](https://calcite.apache.org/docs/reference.html#json-functions) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
