and tables are related through foreign keys. SQL is used to declare the data to be returned, and a SQL query processor and query optimizer turn the SQL declaration into a query plan that is ...

so I suggest using a graphical database client with a SQL builder. Views are essentially saved queries, which can be treated as though they were tables. Foreign keys enforce table relationships ...