Copying a large number of records from one table, or by joining more than one table, into another table is a frequently performed action in database systems. This straightforward operation can be performed in a number of ways. Many of the popular ORM...
Markdown supported · ⌘↵ to post
Olúwásetèmi Ojo
Developer on a journey. I'm a Developer. I make all sort of stuff with Typescript, JavaScript, React, Nodejs. You can find my work on GitHub
Another good use case is report generation that involves audit trailing the details of the report generated. So one could just pull the data from the source and insert the requested report into a new table on the fly. Lots of great use. Came across it recently. I wonder if orm's like prisma rely on this to return data in any form.