[WIP] CQL 3.3 status

This is a meta-issue, to track supported CQL features.

> P = Parser (AST and parser), does it event parse?  
> S = Schema Engine, does troy understand it  
> M = Does it work with the macro (integration tests)

> ✅ = Implemented and automated test exists (with link to PR)  
> ⚠️ = We have a task for this (with a link to the issue)  
> ❌ = Not going to be implemented (with link to explanation and workaround) 

Note: This is still underprogress, items that doesn't any signs next to it, means we didn't update the document yet.

# Basics

| Feature | P |  S |
| --- | --- | --- |
| [Case insensitive and double quotes](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/ucase-lcase_r.html) | ⚠️ #128 | ⚠️ |
| [Escaping Characters : Single Quote](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/escape_char_r.html) | ✅ #91  | ✅ |
| [Escaping Characters: Dollar Sign](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/escape_char_r.html) | ⚠️ #130 | ⚠️ |
| [Comments](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlRefComment.html) | ⚠️ #122 | ⚠️ |
| [Keywords](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/keywords_r.html) | ✅ #133  | ✅ | ✅ |

# Data types

| Feature | P |  S | M |
| --- | --- | --- | --- |
| [Primitives](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cql_data_types_c.html) | ✅ | ✅ | ✅ |
| [Blob](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/blob_r.html) | ✅ | ✅ | ✅ |
| [UUIDs ](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/uuid_type_r.html) | ✅ | ✅ |  ✅|
| [Timestamp](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/timestamp_type_r.html) | ✅ | ✅ | ✅ |
| [Tuple](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/tupleType.html) | ⚠️ |⚠️  | ⚠️ |
| [UDT](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlRefUDType.html) | ⚠️  #9  | ⚠️ | ⚠️ |
| [list](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/collection_type_r.html) | ✅ | ✅ | ✅ |
| [set](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/collection_type_r.html) | ✅ | ✅ | ✅ |
| [map](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/collection_type_r.html) | ✅ | ✅ | ✅ |
| [frozen](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/collection_type_r.html) | ⚠️ | ⚠️ | ⚠️ |


# Functions

| Feature | P |  S | M |
| --- | --- | --- | --- |
| [Blob](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/blob_r.html) | ✅ #125 | ⚠️ |  |
| [UUIDs](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/timeuuid_functions_r.html) | ✅ #125 | ⚠️ |  |
| [Token](http://docs.datastax.com/en/cql/3.3/cql/cql_using/useToken.html) | ✅ #125 | ⚠️ |  |
| [Writetime](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlSelect.html#reference_ds_d35_v2q_xj__retrieving-the-datetime-a-write-occurred) | ✅ #125 | ⚠️ |  |
| [TTL](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlSelect.html#reference_ds_d35_v2q_xj__ref-select-ttl) | ✅ #125 | ⚠️ |  |
| [Aggregations](http://docs.datastax.com/en/cql/3.3/cql/cql_using/useQueryStdAggregate.htmll) | ✅ #125 | ⚠️ #134 |  |
| [UDF](http://docs.datastax.com/en/cql/3.3/cql/cql_using/useQueryUDF.html) | ✅ #125 | ⚠️ |  |
| [UDA](http://docs.datastax.com/en/cql/3.3/cql/cql_using/useQueryStdAggregate.html) | ✅ #125 | ⚠️ |  |



# Statements
## Data Manipulation (Queries)

| Feature | P |  S | M |
| --- | --- | --- | --- |
|[SELECT](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlSelect.html)|  |  |  |
|[INSERT](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlInsert.html)|  |  |  |
|[UPDATE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlUpdate.html)|  |  |  |
|[DELETE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDelete.html)|  |  |  |

## Data Definition (Schema)

| Feature | P |  S | M |
| --- | --- | --- | --- |
|[ALTER KEYSPACE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlAlterKeyspace.html)|  |  |  |
|[ALTER MATERIALIZED VIEW](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlAlterMaterializedView.html)|  |  |  |
|[ALTER ROLE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlAlterRole.html)|  |  |  |
|[ALTER TABLE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlAlterTable.html)|  |  |  |
|[ALTER TYPE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlAlterType.html)|  |  |  |
|[ALTER USER](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlAlterUser.html)|  |  |  |
|[BATCH](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlBatch.html)|  |  |  |
|[CREATE AGGREGATE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateAggregate.html)|  |  |  |
|[CREATE CUSTOM INDEX (SASI)](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateCustomIndex.html)|  |  |  |
|[CREATE INDEX](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateIndex.html)|  |  |  |
|[CREATE FUNCTION](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateFunction.html)|  |  |  |
|[CREATE KEYSPACE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateKeyspace.html)|  |  |  |
|[CREATE MATERIALIZED VIEW](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateMaterializedView.html)|  |  |  |
|[CREATE TABLE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTable.html#ref-create-table)|  |  |  |
|[CREATE TRIGGER](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTrigger.html)|  |  |  |
|[CREATE TYPE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateType.html)|  |  |  |
|[CREATE ROLE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateRole.html)|  |  |  |
|[CREATE USER](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateUser.html)|  |  |  |
|[DROP AGGREGATE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropAggregate.html)|  |  |  |
|[DROP FUNCTION](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropFunction.html)|  |  |  |
|[DROP INDEX](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropIndex.html)|  |  |  |
|[DROP KEYSPACE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropKeyspace.html)|  |  |  |
|[DROP MATERIALIZED VIEW](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropMatializedView.html)|  |  |  |
|[DROP ROLE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropRole.html)|  |  |  |
|[DROP TABLE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropTable.html)|  |  |  |
|[DROP TRIGGER](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropTrigger.html)|  |  |  |
|[DROP TYPE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropType.html)|  |  |  |
|[DROP USER](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlDropUser.html)|  |  |  |
|[GRANT](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlGrant.html)|  |  |  |
|[LIST PERMISSIONS](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlListPermissions.html)|  |  |  |
|[LIST ROLES](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlListRoles.html)|  |  |  |
|[LIST USERS](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlListUsers.html)|  |  |  |
|[REVOKE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlRevoke.html)|  |  |  |
|[TRUNCATE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlTruncate.html)|  |  |  |
|[USE](http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlUse.html)|  |  |  |

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[WIP] CQL 3.3 status #127

Basics

Data types

Functions

Statements

Data Manipulation (Queries)

Data Definition (Schema)

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Feature	P	S
Case insensitive and double quotes	⚠️ #128	⚠️
Escaping Characters : Single Quote	✅ #91	✅
Escaping Characters: Dollar Sign	⚠️ #130	⚠️
Comments	⚠️ #122	⚠️
Keywords	✅ #133	✅

Feature	P	S	M
Primitives	✅	✅	✅
Blob	✅	✅	✅
UUIDs	✅	✅	✅
Timestamp	✅	✅	✅
Tuple	⚠️	⚠️	⚠️
UDT	⚠️ #9	⚠️	⚠️
list	✅	✅	✅
set	✅	✅	✅
map	✅	✅	✅
frozen	⚠️	⚠️	⚠️

Feature	P	S
Blob	✅ #125	⚠️
UUIDs	✅ #125	⚠️
Token	✅ #125	⚠️
Writetime	✅ #125	⚠️
TTL	✅ #125	⚠️
Aggregations	✅ #125	⚠️ #134
UDF	✅ #125	⚠️
UDA	✅ #125	⚠️

Feature	P	S	M
ALTER KEYSPACE
ALTER MATERIALIZED VIEW
ALTER ROLE
ALTER TABLE
ALTER TYPE
ALTER USER
BATCH
CREATE AGGREGATE
CREATE CUSTOM INDEX (SASI)
CREATE INDEX
CREATE FUNCTION
CREATE KEYSPACE
CREATE MATERIALIZED VIEW
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE ROLE
CREATE USER
DROP AGGREGATE
DROP FUNCTION
DROP INDEX
DROP KEYSPACE
DROP MATERIALIZED VIEW
DROP ROLE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP USER
GRANT
LIST PERMISSIONS
LIST ROLES
LIST USERS
REVOKE
TRUNCATE
USE

Feature	P	S	M
SELECT
INSERT
UPDATE
DELETE