susStringly typed
Ah, the SQLite approach!
God, I’m so over SQL.
It’s great, but it is so old and shows it. Feels like 99% of my SQL queries are just cheese.
Works though, and quick.
mesaSQL is the only bedrock in my entire career. Its the one thing that has stayed relevant.
SQL is great but when you start having issues processing what is actually going on, its fine to pull out what you need and throw another language on top (python, C#, etc...etc...). Getting it to work slow is one step in making it fast again.
Yeah it’s curious that it hasn’t really undergone some major changes or had some major challengers (except NoSQL I guess).
It has though
Window functions were an addition, but more recently struct, json, and array fields with native support. Pipe syntax is getting multiple implementations.
Match recognize is a whole new standard abstraction of window functions.
Union by name is being added (fuck union by position).
Isn’t this more like evolution or even just optimisation? I mean it doesn’t seem like a fundamental shift (can be wrong, just checked it out quickly).
Sure, i think its just sql has not had any breaking version changes in like… ever?
Yeah, that’s really one in a kind for such an important feature.