Re:SQL language proposal: JOIN FOREIGN
by dolmen on Thursday December 30, 2021 @05:50PM
(#29742503)
SQL is not only written in an SQL client. SQL is also written (and read from) embedded/mixed in an other programming language were tooling is not always available.
Having to know the names of foreign keys (in addition to the column names of the 2 tables) is adding more cognitive load. I don't think that is an improvement.
Re:SQL language proposal: JOIN FOREIGN
by Latty on Thursday December 30, 2021 @06:39PM
(#29742979)
At least when it comes to both JetBrains and VSCode, they can handle one language embedded in another. I'm kind of surprised there are environments that don't handle that these days.
Having to know the names of foreign keys (in addition to the column names of the 2 tables) is adding more cognitive load. I don't think that is an improvement.