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 Documentation<https://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