shameless plug (for MySql) : https://github.com/o1lab/xmysql/

  supports where clause in intuitive way in queryinh
  provides 'many' apis for groups 
  provides api for join