News for hackers. Stuff that matters.

A comment on Show HN: Trilogy – A Reusable, Composable SQL Experiment. Parent comment

Re:Show HN: Trilogy – A Reusable, Composable SQL Experiment by thesz on Monday November 25, 2024 @03:35PM (#42239916)
> 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.

[ Parent | on HN ]
Re:Show HN: Trilogy – A Reusable, Composable SQL Experiment by hobofan on Monday November 25, 2024 @03:51PM (#42240062)
> 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.

[ Parent | on HN ]