I found the developer experience of EdgeDB to be really great. A CLI tool that does all the work, a very declarative schema language that is easy to learn, migrations built in. Helpful error messages
The dotnet and TypeScript libraries were great as well. All around a fun DB to use, and it builds on PostgreSQL instead of reinventing the wheel.
It's really hard to get people to not-use SQL and one should always look what tool is right for the problem. But I hope a lot of more tools/libraries aim for this kind of enjoyable experience.