I'm thinking about writing a new programming language: an ANSI SQL compatible language that natively interoperates with real code (Python, Typescript, Rust, etc.) and lets you manage your data model, views, etc. as 1st class programming constructs.

Essentially like "DBT" but backed by a real SQL compiler/optimizer/interpreter. Appreciate feedback! And if anyone wants to collab/brainstorm let me know.

Attempting to ask in a non pretentious way: which aspect feels (ontologically) difficult?

Sounds like an ontologically daunting task! Perhaps there is an existing database suitable for data modeling, perhaps dealing in graphs and a DSL that is SQL-like?

Technowatermelon. Elder Millenial. Building Farcaster. 

nf.td/varun

Early thoughts: it will have a SQL parser, binder, optimizer, and interpreter (which either pushes to SQL database, NoSQL database, or runs locally) so you can run against local files, multiple databases, NoSQL, etc. without having to rewrite code. https://i.imgur.com/JO8LgbM.png

that's a very interesting idea - what does the runtime look like?