[Feature Request or Bug] Ability to write a SQL Insert statement against a Virtual Entity

[tony-mykhaylovsky-va]

Hi Mark,

We have a Virtual Entity, for which the Create Event Handler is registered. I am able to trigger the Create event when I add a new record through a form, but when I run the SQL below, it does not trigger the Create event:

insert into ops_test (ops_externalsnapshotid, ops_benefitid, ops_firstname, ops_lastname)
values ('8BE96ADA-155F-EF11-BFE3-001DD8301EFA', '123456789', 'James', 'Bond')

When we create a virtual entity record through a form, we see the following in sequence (in case this helps):

1. Create Event
2. Retrieve Event
3. Retrieve Event

Error:
Object reference not set to an instance of an object.
See the Execution Plan tab for details of where this error occurred

Thank you for creating and maintaining SQL 4 CDS. Incredible tool.

Best,
Tony