Hi Markus, I don't think basex provides such a thing, MarkLogic has something approaching : https://docs.marklogic.com/guide/sql SQL Data Modeling Guide — MarkLogic 10 Product Documentationhttps://docs.marklogic.com/guide/sql MarkLogic is the only Enterprise NoSQL Database. This guide includes the following chapters: SQL on MarkLogic Server; SQL on MarkLogic Server Quick Start docs.marklogic.com
What do you want to achieve ?
IMHO, you will not find a better solution than XQuery to transform xml/json documents. Couchbase (json) invented its own SQL based N1QL language... not sure this is a total success.
To obtain something similar to MarkLogic SQL with BaseX you could simply :
* define flat (tabular) views of your xml data in XQuery * export them to csv or json files * plug on these exports any SQL engine working directly on files (dremio?)
Best regards, Fabrice
________________________________ De : BaseX-Talk basex-talk-bounces@mailman.uni-konstanz.de de la part de Markus Elfring Markus.Elfring@web.de Envoyé : vendredi 20 mai 2022 12:27 À : Martin Honnen martin.honnen@gmx.de; basex-talk@mailman.uni-konstanz.de basex-talk@mailman.uni-konstanz.de Objet : Re: [basex-talk] ODBC support for BaseX?
Is any support available for data management by interfaces like the following?
- Open Database Connectivity
- Java Database Connectivity
Are you just looking for https://docs.basex.org/wiki/SQL_Module?
No. (Not for related use cases at the moment.)
This module is useful for accessing relational databases from XQuery using SQL.
I became curious also for data exchange in the other direction according to such a programming interface. Can any BaseX databases be represented as ODBC (or JDBC) data sources?
Regards, Markus