I use Metabase personally on a daily basis just to allow me to run queries on multiple databases from one place rather than loading multiple scripts into something like DBeaver.
One thing however that really bothers me is the inability to handle input.
For example, I have a query that searches a table for records and provides a sum of a value based on either username or id. I'd like to have field where I can enter in an id or username, and it will handle it.
I can use this syntax to handle it, [[WHERE username = {{username}}]] but it only works when there is one. If I try to do this twice, to handle two potentially different approaches, it fails demanding a value for username.
There are other situations where I want to make other queries based on information, for example.
Let's say I want to search by monthly, daily, or yearly. I want to have a dropdown that represents this "Daily", "Monthly", "Yearly", but these values are not what the query uses. There is no way to have one value for the query, and one for the dialog.
Some of these may be more than just a drop in replacement change to the query.
Having some more power how we create variables and how they are reflected in queries would be a huge help.
, sorry