Support MSSQL's prepared statements

appsignal / sql_lexer

Rust library to lex and sanitize SQL

Apache License 2.0

20 stars 2 forks source link

Support MSSQL's prepared statements #13

Open jeffkreeftmeijer opened 6 years ago

jeffkreeftmeijer commented 6 years ago

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. 👴🏻

jeffkreeftmeijer commented 6 years ago

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

jeffkreeftmeijer commented 5 years ago

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

jeffkreeftmeijer commented 4 years ago

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

jeffkreeftmeijer commented 4 months ago

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