9 ms·
Depending on the skills and needs of the people doing the queries, just provide a set of template SQL queries. My wife frequently need to query sales data from
by mrweasel 2y ago
Depending on the skills and needs of the people doing the queries, just provide a set of template SQL queries. My wife frequently need to query sales data from their POS system. The developers provide small SQL query window, along with a set of predefined queries. New templates can be pushed if the database changes and users can easily change parameters or make small modifications to the queries if they need to.