Does a database engine (#SQL or #NoSQL) exists, that allows generating columns from other columns of other rows (maybe even from other tables) in a declarative way?
Something like PostgreSQL's generated columns without the same-row restriction: https://www.postgresql.org/docs/current/ddl-generated-columns.html
I know this is doable using triggers or views or application logic, but it is exactly what I want to avoid doing.
[#]programming #databases
=> More informations about this toot | View the thread | More toots from mrc@mastodon.berlin
=> View sql tag | View nosql tag | View programming tag | View databases tag This content has been proxied by September (3851b).Proxy Information
text/gemini