Write an SQL query builder in 150 lines of Python

Re:Write an SQL query builder in 150 lines of Python by tshaddox on Friday August 27, 2021 @03:19PM (#28331908)

That seems to assume some very specific "scene" of developers, or at least a team environment where it's impossible to select for developers who know SQL. That may very well be the case in your situation, but I see no reason to expect it would be the case in most situations. SQL isn't exactly a new or niche language.

[ Parent | on HN ]

Re:Write an SQL query builder in 150 lines of Python by kbenson on Friday August 27, 2021 @04:40PM (#28332738)

I'm not talking about plain SQL, I'm talking about the included procedural language that often ships with it[1] as an extension and which is much more DBMS specific.

So, the question is, does your team know SQL/PSM, or PL/SQL, or PL/pgSQL, or some other variant, and how well.

1: https://en.wikipedia.org/wiki/SQL#Procedural_extensions

[ Parent | on HN ]

Re:Write an SQL query builder in 150 lines of Python by tshaddox on Friday August 27, 2021 @06:55PM (#28333876)

My team would know the variant that we use, yes.

[ Parent | on HN ]