Is your feature request related to a problem? Please describe.
We've come across situations where we need to insert and merge more data as part of a sql script than is sane within said script. Currently building up the script with temp table creation and a sizable insert into values collection which is difficult to work with.

Describe the solution you'd like
Support for the OPENROWSET BULK syntax from https://learn.microsoft.com/en-us/sql/t-sql/functions/openrowset-bulk-transact-sql would be ideal.

Queries such as the following...

SELECT *
FROM OPENROWSET(
    BULK 'C:\Data\customers.csv',
    FORMAT='CSV'

) WITH (
    CustomerId  UNIQUEIDENTIFIER,
    Name        NVARCHAR(200),
    Email       NVARCHAR(200)
) AS Data

... as a straight retrieval, but more common examples would be INSERT INTO or using the result of the OPENROWSET in a table join statement.

Describe alternatives you've considered
Current scripts have the data embedded within the script which doesn't scale to large sets of data very well, plus more people can build csv than sql.

Additional context
Add any other context or screenshots about the feature request here.
.