An introduction to Prolog for SQL programers

I've translated the introductory example in Databases: Relational Databases and SQL into Prolog since I've personally found thinking of Prolog as a relational database query language a handy way to get started.

I think I'm using Prolog synonymously with Datalog in these examples, but don't know Datalog that well.

• Basic selection
• Table joins
• order by
• Searching for substrings
• Arithmetic Functions
• Self joins
• Union
• Intersection
• Except
• Subqueries in the where clause
• Subqueries in the from clause
• Subqueries in the select clause
• Three-way Inner Join
• Natural Join With Additional Conditions
• group by queries
• having
• insert
• delete