What is a SQL Intrusion Detection System used for?

It's used to identify SQL injection that has sucessfully bypassed the WAF and the web application. These rogue SQL statements are "knocking at the door" of the database but may not have sucessfully breached the database yet.