---
title: "Comment by Olúwásetèmi Ojo on \"SQL Insert Into Select Statement - An Overview\" | Hashnode"
description: "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"
url: "https://hashnode.com/posts/sql-insert-into-select-statement-an-overview/6150b4757ef2d57e218f1407/comment/61530b6a9c8bfd08f5ba707c"
---

[Discussion](https://hashnode.com/posts/sql-insert-into-select-statement-an-overview/6150b4757ef2d57e218f1407)

Comment [SQL Insert Into Select Statement - An Overview](https://hashnode.com/posts/sql-insert-into-select-statement-an-overview/6150b4757ef2d57e218f1407)

[Olúwásetèmi Ojo](https://hashnode.com/@setemiojo)

[Sep 28, 2021](https://hashnode.com/posts/sql-insert-into-select-statement-an-overview/6150b4757ef2d57e218f1407/comment/61530b6a9c8bfd08f5ba707c)

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.

[Oyekunle Oloyede](https://hashnode.com/@Chief-Oye)

[Sep 28, 2021](https://hashnode.com/posts/sql-insert-into-select-statement-an-overview/6150b4757ef2d57e218f1407/comment/61530b6a9c8bfd08f5ba707c#reply-6153263a414f78089df3af08)

Yes, [Olúwásetèmi Ojo](https://hashnode.com/@setemiojo) It excels at report generation scenarios. I'm not sure if Prisma uses it though, but I've discovered most ORMs do not have a custom support for it. Laravel's Eloquent has some primitive support.
