qDuckDB

qDuckDB has the full power of DuckDB but with BabelDB placed ontop.
BabelDB adds the ability to join data from different data sources and to save any table result locally

Saving a Table Result Locally

To save a result from any database to your local QDUCKDB:

1. Send your query.
2. Click the little DuckIn in the result panel.
3. Enter the new table name.
4. Switch to the QDUCKDB connection.

Joining Data from Different Servers

1. Switch to the QDUCKDB connection.
2. Try sending a query to a single server using the format: query_db('localhost:5000','select from t')
   Note the first argument is the server name in QStudio and the second is your SQL query.
3. Expand the query to be a join and run the query to see the result.
4. Optionally use CREATE OR REPLACE TABLE T AS to save the result.

-- t:([] dt:2013.01.01+til 21; cosineWave:cos a; sineWave:sin a:0.6*til 21) query_db('localhost:5000','select from t'); -- Join data from two separate databases SELECT * FROM query_db('localhost:5000','select from t') a JOIN query_db('weatherdb','SELECT * FROM weather') b ON a.dt = b.date; -- Save the result CREATE OR REPLACE TABLE T AS SELECT * FROM query_db('localhost:5000',{select from t}) a JOIN query_db('weatherdb',{SELECT * FROM weather}) b ON a.dt = b.date; SELECT * FROM T;

BabelDB

For more documentation please see our main BabelDB documentation under the Pulse Help section.