This example is very sharp

1. Native SQL fragment
2. Base query (the focus this time, the query can be treated as the base table for FROM and JOIN, even including optional CTE support)
3. Jimmer and raw statements for GraphQL-style fetchers

Everything is demonstrated clearly.

No matter who looks at this example, they should understand that if SQL can write it, Jimmer DSL can definitely write it.