How do you detect SQL injection attacks

Question

Securing our web applications against SQL injection is a top priority. While I know that using prepared statements and input validation is essential, I’m also looking to implement detection mechanisms. Specifically, I’m interested in:

• Methods or tools to monitor and log SQL queries for suspicious patterns.
• Anomaly-based vs. signature-based detection techniques.
• Real-world examples of how such detection systems have been implemented. Any detailed explanations or recommendations on tools and frameworks for detecting SQL injection attacks would be very helpful.