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

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