jOOQ.scala

select (                                                    
  T_BOOK.ID * T_BOOK.AUTHOR_ID,    
  T_BOOK.ID + T_BOOK.AUTHOR_ID * 3 + 4,
  T_BOOK.TITLE || " abc" || " xy" 
)                                 
from T_BOOK
leftOuterJoin (
  f select (x.ID, x.YEAR_OF_BIRTH)
  from x                          
  limit 1                         
  asTable x.getName()             
)                                 
on T_BOOK.AUTHOR_ID === x.ID      
where (T_BOOK.ID <> 2)            
or (T_BOOK.TITLE in ("O Alquimista", "Brida"))
fetch