Hi Lukas Thank you for quick response.
We are using jOOQ library only to build SQL queries. We are using Spring to fetch data from database, we pass built SQL query to JdbcTemplate. Context usage example from our system is http://pastebin.com/bvatSuZC as result we get query: select "p".id_object, "p".ptype, "p".pvalue, "ug".depth from (user_groups(:requesterUserId)) as "ug" join (permissions) as "p" on ("ug".id_subject = "p".id_subject and "ug".subject_type = "p".subject_type) We can't use code generated by schema, because one of our use cases is to allow querying user defined tables. Maxim
