SCQL Implementation Status
==========================

SELECT Statement
----------------

+-----------------+-----------------------------+------------------------------------------+
|     syntax      | supported(fully/partial/no) |                  notes                   |
+=================+=============================+==========================================+
| join            | partial                     | - currently only inner join is supported |
|                 |                             | - keyword ``using`` is not supported yet |
+-----------------+-----------------------------+------------------------------------------+
| where clause    | fully                       |                                          |
+-----------------+-----------------------------+------------------------------------------+
| group by clause | fully                       |                                          |
+-----------------+-----------------------------+------------------------------------------+
| having clause   | fully                       |                                          |
+-----------------+-----------------------------+------------------------------------------+
| union           | no                          | coming soon                              |
+-----------------+-----------------------------+------------------------------------------+
| limit clause    | no                          |                                          |
+-----------------+-----------------------------+------------------------------------------+
| order by clause | no                          |                                          |
+-----------------+-----------------------------+------------------------------------------+


Functions and Operators
-----------------------

+-------------+----------------------------+-----------------------------+------------------------------------------+
| Category    | Functions and Operators    | supported(fully/partial/no) | notes                                    |
+=============+============================+=============================+==========================================+
| aggregation | sum                        | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| aggregation | count                      | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| aggregation | avg                        | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| aggregation | min                        | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| aggregation | max                        | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| arithmetic  | add,minus,mul,div,intdiv   | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| logical     | logical_and,logical_or,not | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| compare     | <,<=,>,>=                  | partial                     | string data comparison is not supported  |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| compare     | =, !=                      | fully                       |                                          |
+-------------+----------------------------+-----------------------------+------------------------------------------+
| in          | in, not in                 | partial                     | all arguments should be of the same type |
+-------------+----------------------------+-----------------------------+------------------------------------------+