在数据层上加这样一个东西合理吗?

[iugo]

不特指某一种语言.

两张表, 用户表和成绩表

用户表:
userid, name, age

成绩表:
testid, userid, scores, time

select = select('userid', '12');
data = {'name': 'Jim'};
write = query(select, data);

select = select('userid', '13');
data = {'name': 'Sam', 'age': '21'};
write = query(select, data);

select = select('userid', '13');
data = ['name', 'age'];
read = query(select, data);

select = select('userid', '13');
data = {'find': 'test', 'field':['scores', 'time']};
read = query(select, data);

如果这个东西加上比不加好, 那么这样写合理吗?

[rming]

通过外键关联查询么
http://www.yiiframework.com/doc/guide/1.1/zh_cn/database.arr#sec-3

http://laravel-china.org/docs/5.0/eloquent#querying-relations

https://docs.djangoproject.com/en/1.8/ref/models/querysets/#select-related

仅供参考

[xierch]

关系型数据库在 table 之上还有一层 view 吧
直接查询 view 的话就不用 join 了？

[workwonder]

Try Django