I don't want to learn your query language (2018)

Re:I don't want to learn your query language (2018) by stickfigure on Wednesday March 10, 2021 @10:19AM (#26412105)

> SQL queries from another programming language without an ORM means that you do everything by manipulating strings by hand, with zero type safety.

This is not true at all. If you connect IntelliJ to your database (which you should - the query tools are fantastic), it becomes incredibly good at validating SQL strings in code. Even when doing crazy conditional construction.

I like ORMs. I use Hibernate a lot. But I write all my queries in native SQL.

[ Parent | on HN ]

Re:I don't want to learn your query language (2018) by dgellow on Wednesday March 10, 2021 @11:23AM (#26412877)

Do you have a link to Intellij documentation for this feature? That sounds interesting.

[ Parent | on HN ]

Re:I don't want to learn your query language (2018) by andylynch on Wednesday March 10, 2021 @01:13PM (#26414182)

Here you go:

https://blog.jetbrains.com/idea/2020/06/language-injections-... (Overview with link to the full docs)

It’s been a while since I’ve used it but it works great (and not just for SQL but pretty much anything IntelliJ knows about).

[ Parent | on HN ]

Re:I don't want to learn your query language (2018) by dgellow on Wednesday March 10, 2021 @03:58PM (#26416138)

Thank you!

[ Parent | on HN ]