The latest articles on DEV Community by Bilal Ibrar (@bilal_spectral). https://dev.to/bilal_spectral https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3940461%2F20b41c14-fb90-4d19-9f48-07e086d58d91.png https://dev.to/bilal_spectral en Bilal Ibrar Tue, 19 May 2026 14:18:32 +0000 https://dev.to/bilal_spectral/doubling-the-speed-of-an-already-fast-sql-parser-using-ai-298 https://dev.to/bilal_spectral/doubling-the-speed-of-an-already-fast-sql-parser-using-ai-298 <p>Our SQL parsers are among the fastest, if not the fastest, in the world. Once you have something highly optimized, it's very hard to get further tangible gains. Yet I managed to double their speed, and I wouldn't have been able to do so without AI. For the not-so-optimized code, the gains were incredible. Binding is now up to 100x faster and memory consumption down by up to 60x.</p> <p>I just checked the impact on <a href="https://www.spectralcore.com/sqltran" rel="noopener noreferrer">SQL Tran</a> and it now takes 20 seconds to parse SQL, perform a static analysis pass, and translate full 2.7 million SLOC Oracle schema to Postgres.</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Faef78k5kl19690ylomy9.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Faef78k5kl19690ylomy9.png" alt=" " width="800" height="222"></a></p> <p><a href="https://www.spectralcore.com/blog/optimizing-code-with-ai" rel="noopener noreferrer">Continue reading</a></p> <p>Authored by Damir Bulic (CEO, Spectral Core), this post originally appeared on the <a href="https://www.spectralcore.com/blog/optimizing-code-with-ai" rel="noopener noreferrer">Spectral Core blog</a>. Spectral Core builds database migration and SQL analysis tooling: our parsers cover every major SQL dialect and are a core part of what makes large-scale migrations fast.</p> dotnet performance sql ai