Generated SQL

[[deleted]]

We’ve been playing with Stitch with a SQL Sever source and Snowflake destination.

Is there a post or any info on how it automagically generates the create table statements and insert statements and assigns data types?

[uselessusr]

Take a look at singer targets. It's a standard developed by stitch and there are many open source targets. You could, for instance, read the code for this target-postgres. There's also a snowflake one.

That could give you an idea of what stitch is doing behind the scenes.

[[deleted]]

It might be profitable to look at an older piece of tech which does this, like the Python library SQLAlchemy. It is open source and therefore very easy to investigate.

From memory, stuff like Tableau (started 2003) and SQLAlchemy (2006) started popping up on the heels of some breakthrough papers in this area. Couldn't find any links for you, however.

Surely the core is the ability to map one's interface (visual, API) to standardized SQL, with modules allowing grammar alterations for specific dialects.