Been wanting something like this for years over at Exponent. We do a lot of targeted and dynamic emails to our users based on their role and progress through ou

Been wanting something like this for years over at Exponent. We do a lot of targeted and dynamic emails to our users based on their role and progress through our courses, and it’s a pain to not only synchronize the database with the mail provider, but to agree on a system for capturing the state of the user that works with the platform - we’ve ended up creating a complex system of tags that has to be maintained across both systems. Re: non technical users, one idea would be an ability to save “audiences” using smaller SQL queries, that way non-technical collaborators could easily send a campaign to a well-defined group of users, and update the group definition once instead of across all your emails. If you could infer the structure of the connected database automatically and control which tables are visible in the product, people might find that really helpful too (check out Metabase as an example product that does a great job at querying data sources with UI and raw SQL)