Database View
A database view is a saved query that behaves like a virtual table, letting you encapsulate complex logic and expose a simplified, reusable interface to data.
A view stores a SELECT statement under a name. Querying the view runs the underlying query, so you can hide joins and calculations behind a clean, table-like surface.
Views are great for reporting and for shaping data for an API: define a metric or denormalized shape once, then read it everywhere. Materialized views go further by caching results for speed.
With a PostgREST-style API, a view is exposed as an endpoint just like a table, making complex queries available to clients without custom code.
Related terms
See it in practice
Kolaybase gives you PostgreSQL, auth, storage, and a REST API in minutes.