Multi-platform SQL Query Calculator

Does anyone know a tool that can verify that a given SQL statement is valid for different databases (oracle, db2, mssql)?

+3
source share
1 answer

Honestly, I think the best thing you can do is to write your own simple test harness that connects to different test databases (I assume you have a database of every taste to test against), executes your expression and checks the answer. In this regard, it will also serve as a unit test tool for all of your database code. I believe that you could knock something together in your language of choice after about 20 minutes, which is probably not a tool for this.

+2
source

Source: https://habr.com/ru/post/1699442/


All Articles