I've also had similar use cases in this domain (i.e. SQL + email):
* When a new row is entered into my 'contact' table, I'd like an email to be sent to me
* Create a VIEW (e.g. last weeks sales) then send the results of it each day to a list of people (e.g. sales team)
Does anyone else have this pain point? i.e. "integrating email into your Postgresql database". I've tried using Zapier but it doesn't offer exactly what I want
So I was thinking of building something like this: https://imgur.com/a/S54o7ea
Should I build this or is it a terrible idea?