AFAIK, no NoSQL database fully supports SQL, and only some offer support for transactions and joins. The idea here is to augment a relational database by adding capabilities for dynamic relationships.
You're welcome.
Agreed, this article is old, but I think it does a good job of showing how similar Alpine and Vue are.
That idea crossed my mind too. AFAIK, you can't really use SQL in graph databases, and that's a deal breaker for me.
Yes, that's correct. Here's how an entry in the join table looks like: