Prolog isn't a DBMS, it's a functional / logic programming language. It doesn't store tables or operate on relational algebra.

How would you CRUD data DDL, DQL, DML, DCL, TCL against tables (not facts or variables) without SQL? Magic?

And why are you cobbling queries together manually and not using an ORM or library? SMH.