Update materialize doc with simpler SQL

[ecordell]

I think a single select comes off as simpler to grok right now.

The motivation here was that when I was grafting materialize onto an existing project for a demo, I found the ORM that project used made it much easier to build non-union queries.

My only concern with this example is that non-inner joins are much less common and might be confusing in their own right - might be worth coming back to this and expanding on the reason (in this case it's because we don't want to discard rows from the join if they don't have a set_to_set match, since they might have a "direct" member_to_set match.)

[vercel]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
docs	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Dec 19, 2024 3:14am

[tstirrat15]

This makes sense to me. I don't think non-inner joins are too big a hurdle, especially for the users that we'd be expecting to use this.