I really like NATS, but it's worth noting that it's only really "the SQLite of queues" in the context of their Go client, which can embed a NATS server into an application.
Otherwise I would really say it is more like the Postgres of queues (still great, but potentially not what OP is looking for)
It's a single binary and can operate as a message bus, persistent queue, KV store, object store, provide services, and so on.