StellarSQL (Structured Query Language) is the standard language used to interact with relational databases. It allows users to manage structured data, which is typically stored in tables. SQL provides several key commands to manipulate and query this data.
SELECT command is used to retrieve data from one or more tables. You can specify which columns to fetch and apply filters to narrow down the results.
INSERT command is used to add new records to a table. You specify the table and provide values for each column in the record.
UPDATE command allows you to modify existing records in a table. It is commonly used to change values in one or more columns based on certain conditions.
DELETE command removes records from a table. Like UPDATE, it is usually accompanied by a condition to specify which records should be deleted.