3 ms·
This is another area where I wish SQL was more composable. I’d love to be able to specify a bunch of columns using a single reference or a function, without ha
by mr_toad 2y ago
This is another area where I wish SQL was more composable. I’d love to be able to specify a bunch of columns using a single reference or a function, without having to resort to dynamic sql. Exclude and rename are a start, but not enough.
- sgarland 2y agoSo make a VIEW, then SELECT * from that. Non-materialized views are effectively free as far as the DB is concerned; make hundreds of them if you want.