---
title: "Discussion on \"SQL Insert Into Select Statement - An Overview\" | Hashnode"
description: "Discussion on \"SQL Insert Into Select Statement - An Overview\". SQL Insert Into Select Statement"
url: "https://hashnode.com/posts/sql-insert-into-select-statement-an-overview/6150b4757ef2d57e218f1407"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [SQL Insert Into Select Statement - An Overview](https://chief-oye.hashnode.dev/sql-insert-into-select-statement-an-overview?utm_source=hashnode&utm_medium=feed)

SQL Insert Into Select Statement

Sep 26, 2021 · 5 min read · chief-oye.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#databases](https://hashnode.com/tag/databases)
-   [#backend](https://hashnode.com/tag/backend)
-   [#data-science](https://hashnode.com/tag/data-science)

## Written by

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

@Chief-Oye

  
[View profile](https://hashnode.com/@Chief-Oye)

Software Engineer

Software Engineer. Tinkerer. Incurable learner.

## Responses 1

Markdown supported · ⌘↵ to post

[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.
