Skip to main content

SQL Syntax

Welcome to the Introduction page for the SQL Syntax category in WormSQL! In this section, we'll provide a brief overview of the SQL syntax supported by WormSQL. You can find more in-depth examples and details by browsing the other pages in this category.

WormSQL is a SQL database engine written in Rust, designed to be lightweight, fast, and easy to integrate with various data storage systems. It supports a wide range of SQL features, including creating and managing tables, inserting and updating data, and performing various types of queries.

Here's a list of some basic SQL statements you can use with WormSQL:

Selecting Data

SELECT column1, column2, ... FROM table_name WHERE conditions;

For a complete list of supported SQL features, you can visit the WormSQL GitHub repository's test suite folder, even if you're not familiar with Rust code: https://github.com/Wormsql/Wormsql/tree/main/test-suite/src

This folder contains tests for all the functionalities supported by WormSQL, providing you with an extensive reference for syntax and usage.

Feel free to explore the other pages in this category to dive deeper into WormSQL's SQL syntax and capabilities!