Test, validate and match regular expressions
Matches SQL LIMIT-OFFSET pagination clauses in queries, case-insensitively across multiple lines. It captures the 'limit' keyword, an optional numeric row count, the 'offset' keyword, intermediate content, and a trailing optional number (e.g., 'LIMIT 10 OFFSET 5'). Useful for SQL query parsing, validation, extracting pagination parameters, or syntax highlighting in JavaScript applications.