4 ms·
Hello, you may like to try out what we've been working on at Holistics (www.holistics.io)! We make it easy for you to retrieve and share your SQL data. We help
by aceregen 9y ago
Hello, you may like to try out what we've been working on at Holistics (www.holistics.io)! We make it easy for you to retrieve and share your SQL data.
We help in 2 use-cases to address the "duplicative" overhead of writing the same SQL query.
1. Where you just need to adjust specific parameters/values in your query
With Holistics, You can insert custom variables in your SQL query to make them dynamic to address the subtle differences without repeating yourself. See an example here: https://docs.holistics.io/guides/adding-filters/ https://docs.holistics.io/guides/adding-filters/
2. Where you have chunks of text that are reused across multiple questions
This can be long chunks of `CASE-IFs` or CTE/sub-queries that you use across multiple reports. You can insert a template snippet (chunks of SQL syntax for example) that can be reused across multiple questions. You can find more information here: https://docs.holistics.io/query-templates/ https://docs.holistics.io/query-templates/
- meow1032 9y agoThanks for the response, I'm more on the research side of things now, so I don't have a current use case, but thinking about moving back to industry, and it's something that I remember having trouble with when I was last in industry.