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.
@amiloradovsky SQL injection isn't the problem, though - the code in the screenshot is safe from that. The problem is overly dynamic queries with filters and sorting depending on user input. And this is actually a simple example...
@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.
functional.cafe is an instance for people interested in functional programming and languages.