Note: The database uses UUID as a data type for IDs, the tables contain integers as IDs to keep illustration simple.

Very interested in the project, but it looks like your limit / offset syntax for postgres is invalid. Recommended solution is to use OFFSET X LIMIT Y instead. Happy to dig in and submit a PR, if it's ...