(Also here's a gratuitous plug for my employer's product in a similar vein: https://docs.relational.ai/rel/intro/overview)
yes; yes; yes; yes; yes; yes; yes; yes; ...
Datalog, on the other hand, isn't. It's terminating, like SQL. And many program properties are indeed decidable.
Because of it's restrictions it traditionally uses different search/resolution strategies than Prolog. And in the other direction the SLD resolution strategy Prolog traditionally uses can fail on syntactically valid Datalog (clause ordering issues).
That said, the big Prolog implementations all support multiple resolution strategies although I suspect there are a lot of various optimizations Datalog squeezes out of it's restrictions that let it handle things that might not be reasonable in a given Prolog.
Can you elaborate on what you mean by this? Like, custom database implementations? I wrote a little bit of Prolog in college and thought it was neat but I haven't looked at it since. I've seen Datalog mentioned recently in relation to biscuits, a technology I think is incredibly cool but that I don't fully grok.