tursodatabase / libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

https://turso.tech/libsql

MIT License

9.54k stars 252 forks source link

[Feature] Allow sequence creation #1504

Open GustavoOS opened 3 months ago

GustavoOS commented 3 months ago

Description

Suggestion is to allow sequence creation as specified by SQL

Example of Definition

CREATE SEQUENCE sequence_1
start with 1
increment by 1
minvalue 0
maxvalue 100
cycle;

Example of Usage

select sequence_1.next_val

Motivation

Sqlite offers autoincrement, but exposing an autoincrement id to an API may expose the API to attacks
Some id techniques needs the usage of a sequence in order to enforce sequence and associating this sequence to other factors
The generate_sequence function is not capable of returning a new number from a sequence (as next_val)