java - 是否存在根据MYSQL表格自动生成RESTFULL接口的技术?

Question

想咨询各位大神一下，是否存在根据数据库表接口自动生成restfull 接口的技术。
支持

select 
    sum(filedA) as PV ,
    count( distinct filedA) as UV,
    sum( if ( SomeCondition is true , 1 ,0 )) as SumOtherA
from 
    SomeTable 
where 
    filedA   >  0 

更进一步，还能生成多表关联查询的代码，支持各种join 操作。
语言不限，不知道是否有县城的工具？

Answer 1

php version: https://github.com/mevdschee/...

Python version: http://flask-restless.readthe...

Answer 2

The most mature one I know is postgres
https://github.com/begriffs/p...

Answer 3

For php: yii2’s gii can basically satisfy you, but in the end I didn’t try restful~

Answer 4

loopback.io doesn’t know if it has this capability. You need to write some code and configure it a little bit.

Answer 5

xorm and gorm can meet your needs

Answer 6

There are many similar technologies, you can study ActiveRecord