Bulk insert using transformer output

Linking another thread where we bulk inserted with SQL mode so that we can return the newly created records