Support MSSQL's prepared statements

Open jeffkreeftmeijer opened this issue 7 years ago • 4 comments

As reported via support (private Intercom link):

As you can see the SQL reported by MSSQL is performed using prepared statements, with the sanitisation applied the actual query being performed is removed and replaced with a question mark.

ActiveRecord seems to wrap all queries in prepare statements, which the sql_lexer can't handle right now, resulting in queries like this:

Also, here's how to set up MSSQL on your fancy Apple-Books, kids. 👴🏻

Mar 12 '18 07:03 jeffkreeftmeijer

https://app.intercom.io/a/apps/yzor8gyw/inbox/inbox/540654/conversations/16660986713

May 29 '18 10:05 jeffkreeftmeijer

https://app.intercom.io/a/apps/yzor8gyw/inbox/inbox/unassigned/conversations/19423502644

Nov 12 '18 14:11 jeffkreeftmeijer

https://app.intercom.io/a/apps/yzor8gyw/inbox/inbox/540654/conversations/25252473951

Jan 06 '20 11:01 jeffkreeftmeijer

https://app.intercom.com/a/inbox/yzor8gyw/inbox/shared/unassigned/conversation/16410700312839?view=TableFullscreen

May 01 '24 08:05 jeffkreeftmeijer