Add SQL trigger support to v4 model

[lucyzhang929]

More information about SQL Bindings can be found here.

[ejizba]

Added input and output binding support. I'm hesitant to add trigger support while it's still in preview, especially considering users have a workaround with our generic support.

I'd be willing to reconsider if we have users asking for it (upvotes/comments on this issue would be best), otherwise we should be able to do it as soon as it GA's. Feel free to ping us as the GA date approaches

[andreasbhansen]

Any thoughts on adding support for SQL triggers now a half-ish year later, @ejizba? Are there still issues with this functionality which blocks the implementation into @azure/functions?

[ejizba]

It's a question of priority against our other work, not anything blocking it necessarily. I was primarily waiting for the SQL trigger to go GA, but as far as I can tell the docs still list it as preview. If GA won't be for a long time or if we get sufficient user feedback asking for it, we could add it before GA. But to be honest @andreasbhansen you're the first person to ask for it (excluding Lucy who is on the team that developed the sql stuff 😉)

[lucyzhang929]

@ejizba GA for SQL trigger will be very soon! We are currently waiting for a new extension bundle version to be released which will contain our GA bits. Will update here once we are officially GA.

[lucyzhang929]

@ejizba The SQL trigger is now generally available!

[ejizba]

Fyi @andreasbhansen @lucyzhang929 we just released v4.4.0 with SQL trigger support