SQL syntax error when aliasing outcome of a relational division

[lukaseder]

The following query generates a SQL syntax error in most databases:

        create().select()
                .from(TBookToBookStore()
                .divideBy(TBookStore())
                .on(TBookToBookStore_BOOK_STORE_NAME().equal(TBookStore_NAME()))
                .returning(TBookToBookStore_BOOK_ID())
                .as("x")) // Aliasing is not possible
                .fetchOne(0, Integer.class);

... which renders as such

select *
from ((
  select distinct "dividend"."book_id"
  from "public"."t_book_to_book_store" as "dividend"
  where not exists (
    select 1
    from "public"."t_book_store"
    where not exists (
      select 1
      from "public"."t_book_to_book_store"
      where (
        "dividend"."book_id" = "public"."t_book_to_book_store"."book_id"
        and "public"."t_book_to_book_store"."book_store_name" = "public"."t_book_store"."name"
      )
    )
  )
) as "alias_40930429") as "x"

The error obtained is this:

Caused by: org.postgresql.util.PSQLException: FEHLER: Syntaxfehler bei »)«

The reason is that in most SQL dialects, it is not allowed to doubly-nest derived tables with aliases