It’s been a while, but Looker provides LookML, something akin to an ORM for dynamically integrating relations, measures, aggregations, etc. into SQL queries on demand as well as a variety of visualization options for the result set. This is somewhat similar to the architected metadata aspects of SAP Business Objects or Microstrategy. Periscope provides an interface for a developer to manually write a static query and visualize the output similar to Apache Superset. (Cunningham’s Law if this is outdated or otherwise incorrect)