So much easier to write advanced queries compared to SQL. Queries are actually readable! Community on Slack is also very helpful and includes SurrealDB developers.
Use it on two production project. It has some minor problems, but works very well in general
Databases have stagnated for a very long time. There are new improvements, but they have specialized a lot, so if you have 3 different needs you have to install, learn, implement and deploy 3 different DBs and make them work between each other. SurrealDB chooses the hardest and longest path, and actually tries to fix problems in previous architectures/query languages. SurrealQL takes whats best off of SQL and fixes a lot of it's problems. And the Record Links concept not only works wonders but is very performant. Even though SurrealDB is slow on some operations (not only is it still fresh, but it also has chosen the hardest path), if you use Record Links or Complex IDs it scales very well. Even though it's an uphill batte, SurrealDB keeps improving fast. Might not be the nº1 choice at the moment, but I bet it will be in the future.