Yea, I actually thought of the viability of SQL for games while working on DOOMQL. It's just so easy to express a lot of game logic in SQL queries. As an avid OSRS player I was thinking about doing a simple MUD/MMO next.

Thanks for the pointer to SpacetimeDB - haven't heard of it before!

My understanding is that Spacetime db embeds the "system" component of an ECS into a DB. The rest of the ECS is in there too.

I briefly looked into it, but never got past that fundamental piece.