I thought I had finally devised a good method to dynamically construct SQL queries in #Perl, but it turns out I can make a horrible mess of everything.
@ayo Oh, I wasn't criticizing the code in the screenshot per se. But sure the more complex the composed query is, the harder it is to ensure it's safety.
@amiloradovsky That is certainly true. Integrating SQL into the host language type system (if it has a static one, i.e. not Perl) really helps with that, but tends to heavily complicate and limit the flexibility of queries.
@ayo But all the flexibility should only be used on the server anyway.
Welcome to your niu world ! We are a cute and loving international community Ｏ(≧▽≦)Ｏ !