Looking for a workaround for New Row in SQL Server

I’m still finding it hard to believe Zapier made such a change with a major impact but after wrestling with my zaps and recreating them all day I came up with a very cumbersome but functional workaround if anyone else has this issue. 

You need the ability to create a view in your database.
1. Create a view with the exact same columns as your table and nothing else. You can exclude certain columns if you don’t need them
2. Add your SQL Server New Row step. Zapier won’t let you choose a view for this, so add your base table.
3. With all of the columns from the table present, change your table to the view name (helps if you just create the view something like table_vw) 
4. Refresh fields (not sure if this is necessary) and add the pills to your fields. 

While this is not ideal and I’m sure Zapier will break it, it’s preferred to a custom query where pilling all of the Values from the insert is a nightmare. 

another workaround would be a stored proc, but I think you’d run into the same issues with the custom query there. My fallback would be to create a separate table without triggers and then just call a stored proc with another step to insert into my desired table. What a mess.