In 2021 Google introduced Logica, a Datalog variant. In their introduction blog they contrast it with SQL, so this may answer your question:

https://opensource.googleblog.com/2021/04/logica-organizing-...

In short, it's easier to compose (and decompose), which helps with complex queries that can be assembled from simpler, independently tested parts.

No personal experience in this, I just remembered that blog contrasting Datalog and SQL.