July 2017 Summaries

Metabase's query builder allows users to run simple queries on a single table, with the added flexibility of pulling information from tables linked by foreign keys, modifying columns, and creating new ones based on mathematical expressions. While it may not match the power of other tools, it caters to 80% of non-technical users, enabling them to ask a significant portion of their questions. A notable enhancement in the new release is the ability to use saved questions as "tables" in the query builder, facilitating the aggregation or further exploration of results from previous queries, including those created with SQL. This approach avoids the complexity of creating extensive SQL templates or using proprietary languages, instead allowing standard SQL for subqueries. Users can also perform joins within these nested sub-questions using standard SQL, making the process straightforward for those familiar with SQL syntax. Metabase plans to expand the query builder's capabilities, focusing on areas where SQL is less effective and enhancing the interface for non-technical users. While nested queries may affect performance, optimization through materialized views and batch processes is recommended. Users are encouraged to experiment with nested queries and provide feedback for future improvements, with feature enhancements prioritized based on user demand.