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

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