Roadmap v0.5

[Fedomn]

Introduce distinct and subquery:

-- distinct
select distinct state from employee;
select count(distinct(b)) from t2;
-- alias
select a as c1 from t1 order by c1 desc limit 1;
select t.a from t1 t where t.b > 1 order by t.a desc limit 1;
-- subquery
select t.* from (select * from t1 where a > 1) t where t.b > 7;
select a, (select max(b) from t1) max_b from t1;

• distinct
  • [x] #62
  • [x] #64
• alias
  • [x] #70
  • [x] #72
• subquery
  • [x] #66
  • [x] #74
  • [x] #76
  • [x] #78
  • [x] #79
  • [ ] #67
  • [ ] #68
• bugfix
  • [x] #82
  • [x] #83
• refactor
  • [x] #87
  • [x] #89