We are developing an interface to our internal data storage and manipulation tool that would allow people to use SQL dialect.

We decided that it would be perfect to make our SQL dialect as close to the standard as possible.

Currently I'm trying to find a tool that would test our implementation of query language and make a verdict about its compliance and list missing details.

Have anyone ever encountered anything like this?

  • 1
    developer.mimer.com/validator/index.htm but that does not support modern SQL – a_horse_with_no_name Jul 10 '17 at 12:45
  • Great, thank you! But I need exactly the opposite. I need a tool that can send queries to my "database" and then show me the list of features that are not implemented according to one of the standard SQL implementations. – kovalad Jul 10 '17 at 13:45
  • 2
    I think you should write your own tests. Then you can run the tests and the results will show which features are working and which not. You can get an idea and start with Postgres' (regression) tests. – ypercubeᵀᴹ Jul 10 '17 at 14:22

Finally after looking at SQLite unit tests and postgreSQL unit tests we decided to use these tools

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.