SQL Insert Into Select Statement - An Overview
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...
chief-oye.hashnode.dev5 min read
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.