News for hackers. Stuff that matters.
Re:Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalen... by rawgabbit on Thursday September 21, 2023 @12:20AM (#37593178)
Not exactly what you are looking for. But SQL server has several ways to track queries. One is DMV. The other is the Query Store.

https://blog.sqlauthority.com/2010/05/14/sql-server-find-mos...

https://learn.microsoft.com/en-us/sql/relational-databases/p...

Re:Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalen... by lfconsult on Thursday September 21, 2023 @04:17AM (#37594694)
Exact, it's not what I'm looking for but it's interesting anyway, thank you for your answer and the links.

It's a bit weird but I'm using a langage (for a specific project) where prepared statements aren't available (except if you pay or use a specific DBMS, I can't do both because the client won't pay and I need SQLServer).

My initial idea was to use a DLL from PDO (I'm developping on a Windows env) or whatever known piece of code that is trustable in order to sanitize user inputs (of course we do it client side but user is devil :-)) before sending it to SQLServer.

After all answers and my researches, I think that I'll use a tiers piece of code to escape queries (probably a C# program using SQLCommand).

Thanks all.

If anybody knows exactly how SQLServer is handling SQL Statements, please let us know.