felix-reichel / price-search-engine-seals-analysis

Produces a price search engine firm quality seal changes data set of (potentially) skewed index-spaced data cubes within a big data cube.

0 stars 0 forks source link

Build a QueryStringBuilder-Wrapper using the Query Abstraction from Sqeleton (which supports DuckDBDialect>=0.6) #26

Closed felix-reichel closed 1 month ago

felix-reichel commented 1 month ago

Main Concept for Wrapper of the Sqeleton Query Abstraction:

[ ] 0. Install Sqeleton
[ ] 1. Create a second In-memory duckdb Instance, which will act as "Shadow" for the other db.
[ ] 2. Initialize the Shadow Db now by shooting DDL of all SCHEMA_CONFIG 's in it.
[ ] 3. Now, we should be able to build queries without compile errors to obtain valid funky query string using the squeleton abstraction in our Wrapper class.

https://github.com/datafold/sqeleton/blob/master/tests/test_query.py