The EQQ data model has three nouns: Views, Queries, Functions. Many first-time users flatten them into one idea - and then wonder why the app has three menus. Here is the separation that makes EQQ scale.

Views define what data is available

A View is a curated projection of your schema: “from the Customers and Orders tables, here are the columns business users are allowed to query.” Views are where governance lives.

Queries ask a question

A Query reads from a View (or multiple Views) and answers a specific question: “revenue by region for date range X to Y”. Queries are parameterized and versioned.

Functions are reusable logic

A Function (e.g. fQQ_MonthBucket) is a snippet used by many queries. Change the function once, every query using it updates.

Function Categories - the third governance layer alongside Views and Queries.
Function Categories - the third governance layer alongside Views and Queries.

Why three layers, not one

  • The data steward owns Views: curation, access.
  • The analyst owns Queries: specific questions.
  • The power user owns Functions: shared logic.

Each role can iterate independently. Change a View without breaking the analyst's query. Change a Function without rewriting the View. This is the Unix-philosophy applied to database access.

Want to see it live? Book a 30-minute demo - we connect EQQ to your database and build a query with you. Book a Demo →