18

I found this link on Hacker News, and it seems to be a transpiler to generate SQL from a new language.

It's been a long time since I have written SQL, but I'm sure this could be interesting since SQL can be infuriating for most developers I've worked with.

you are viewing a single comment's thread
view the rest of the comments
[-] LPThinker@lemmy.world 2 points 1 year ago

This seems nice in theory, but the tradeoffs make me question it's real world viability. It has to be a transpiled language, because SQL is so ubiquitous is may never die. And yet, because it's a transpiler, I'm skeptical that it will actually be easier to write than SQL, because you'll still need to know all the gotchas and eccentricities of SQL.

Maybe for users who already experts in SQL this would be a quaint alternative syntax. However, personally I've already invested so much time developing familiarity with SQL that I see no advantage in moving to a new syntax that would take more time to become deeply familiar with, and that my co-workers won't understand.

[-] qwertyasdef@programming.dev 2 points 1 year ago

Why would you need to know the eccentricities of SQL? Shouldn't it be enough to just know PRQL? The generated SQL should have the same semantics as the PRQL source, unless the transpiler is buggy.

[-] verstra@programming.dev 2 points 1 year ago

Because when you divide by zero and get a runtime error, the error will point you to location in SQL, not PRQL.

It's like if an error in a C++ program would point you to an offset in a binary and not the location in the source. This has a slight tone of sarcasm, because that's how compiled languages used to work. But after the years, they patched all leaks of their abstraction and now you are dealing just with the new language.

load more comments (4 replies)
load more comments (4 replies)
this post was submitted on 26 Jul 2023
18 points (90.9% liked)

Programming

17248 readers
431 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



founded 1 year ago
MODERATORS