How-to Guides

This section provides problem-oriented solutions for specific tasks and real-world scenarios using General SQL Parser.

• Parse Oracle PL/SQL — packages, procedures, triggers, and EXECUTE IMMEDIATE dynamic SQL
• Handle SQL Server T-SQL — GO batches, blocks, TRY-CATCH, stored procedures, temp tables
• Work with PostgreSQL Extensions — dollar-quoted functions, RETURNING, CTEs, COPY
• Performance Optimization — parser reuse, script splitting, parallel parsing
• Error Handling — syntax error details, batch validation strategies
• Custom Identifier Rules — case sensitivity and identifier normalization