| ▲ | thesz 4 days ago | |
> There needs to be a way to write a query that runs on an abstract interface, rather than an actual table. Proper use of SQL inverts control. Instead of parameterizing query by table, you write a query and at the actual use site you join it on the table you need by fields your query provides. VIEWs allows you to not repeat yourself too often. Best thing is that you do not need to even mention that "abstract interface table" as a parameter at all. | ||
| ▲ | hobofan 4 days ago | parent [-] | |
> VIEWs allows you to not repeat yourself too often. No they don't. They only offer a solution to the problem "many different predicates for a few tables", but don't offer a solution to the problem "a few similar predicates for many different tables", as views as per their declaration are already tied to a single table. | ||