I program in SQL, however I am not someone who comes from IT.
In my new job, we have to choose an open source tool for doing only queries (using SQL language), it means we are going to connect to some transactional databases (MS SQL Server - Analysis Services) for doing queries but no for insert or modify that Databases.
For us, the most important things are:
- A stable tool, having secure connections above all.
- Easy to use (easy to create connections and configurations)
- An if it is possible have a visual interface (workbench for example) because my colleague does not program (she usually worked in Access using the visual interface for doing her queries)
- Better if it permits to do subqueries.
Thank you very much for your advice.