I'm aware of some of the weird behavior and dangerous mistakes I can make with SQL.<p>- Missing indices on join tables.<p>- Postgres columns are case sensitve. MySQL columns are not.<p>- Missing limits on subqueries.<p>- Etc.<p>But now I find myself working on an API backed by a NoSQL db. What do SQL devs like me need to know when they wander into a NoSQL dev shop?<p>I'm curious about the weird footguns as well as the different data modeling approaches. For example, all I know are join tables, but now I'm learning that I can just put a list of objects inside a document.