CQL language preview

1. Creating a table

keywords, column types, and PRIMARY KEY

horizon-dark

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name TEXT,
    age INT,
    created_at TIMESTAMP
);

atom-one-dark

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name TEXT,
    age INT,
    created_at TIMESTAMP
);

github-dark

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name TEXT,
    age INT,
    created_at TIMESTAMP
);

dracula

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name TEXT,
    age INT,
    created_at TIMESTAMP
);

nord

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name TEXT,
    age INT,
    created_at TIMESTAMP
);

github

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name TEXT,
    age INT,
    created_at TIMESTAMP
);

2. Filtering with ALLOW FILTERING

WHERE, ALLOW FILTERING, and bind markers

horizon-dark

SELECT name, age
FROM users
WHERE age > ?
ALLOW FILTERING;

atom-one-dark

SELECT name, age
FROM users
WHERE age > ?
ALLOW FILTERING;

github-dark

SELECT name, age
FROM users
WHERE age > ?
ALLOW FILTERING;

dracula

SELECT name, age
FROM users
WHERE age > ?
ALLOW FILTERING;

nord

SELECT name, age
FROM users
WHERE age > ?
ALLOW FILTERING;

github

SELECT name, age
FROM users
WHERE age > ?
ALLOW FILTERING;

3. Insert with TTL

USING TTL, string escaping, and built-in functions

horizon-dark

-- expire the row after one day
INSERT INTO users (id, name)
VALUES (uuid(), 'O''Brien')
USING TTL 86400;

SELECT count(*), writetime(name) FROM users;

atom-one-dark

-- expire the row after one day
INSERT INTO users (id, name)
VALUES (uuid(), 'O''Brien')
USING TTL 86400;

SELECT count(*), writetime(name) FROM users;

github-dark

-- expire the row after one day
INSERT INTO users (id, name)
VALUES (uuid(), 'O''Brien')
USING TTL 86400;

SELECT count(*), writetime(name) FROM users;

dracula

-- expire the row after one day
INSERT INTO users (id, name)
VALUES (uuid(), 'O''Brien')
USING TTL 86400;

SELECT count(*), writetime(name) FROM users;

nord

-- expire the row after one day
INSERT INTO users (id, name)
VALUES (uuid(), 'O''Brien')
USING TTL 86400;

SELECT count(*), writetime(name) FROM users;

github

-- expire the row after one day
INSERT INTO users (id, name)
VALUES (uuid(), 'O''Brien')
USING TTL 86400;

SELECT count(*), writetime(name) FROM users;