Original query:

select "content".* from "content" where "type" = 'compound' and ("visibility" = 1 or ("visibility" = 0 and "author" = 10)) order by "modify_date" desc

Prettified:

SELECT
  "content".*
FROM
  "content"
WHERE
  "type" = 'compound' AND
  (
    "visibility" = 1 OR
    (
      "visibility" = 0 AND
      "author" = 10
    )
  )
ORDER BY
  "modify_date" DESC