Ask HN: What projects are you working on now?
I&#x27;m working on static analyzer for SQL:
<a href="https:&#x2F;&#x2F;holistic.dev" rel="nofollow">https:&#x2F;&#x2F;holistic.dev</a><p>It&#x27;s a useful tool for DBA to identify issues in SQL queries automatically.
Only 50 rules for now, but more than 1000 described in backlog :)<p>Funny, but initially this tool aimed at developers&#x27; needs.<p>I&#x27;ve made a lot of microservices, which only started the database queries. I came up with the idea of making a tool that would automatically generate all the microservices based on SQL queries. The MVP of such a tool was implemented, which reduced the developer workload by at least a quarter. In this tool, it was required to write queries in a certain way that did not make it universal and did not give a connection with the database structure.<p>The next step was to create a system that relies on the text description of the database schema in SQL format (DDL) and automatically understands the types that will return the SQL query. Such a tool can automatically inform the developer about possible errors on the interface between the application and database when changing the structure or the SQL queries themselves.
It can also be built into the CI to provide the automatic code review at the version control system level and prevent the erroneous code from entering the repository.<p>But the developers did not appreciate all the advantages, as most projects are developed using ORM :(<p>But at the same time, DBAs expressed interest in implementing a system of the automatic search for bad requests already on the production database.<p>Any questions are welcome :)