Menu

What is SQL?

Engineers a long time ago came up with a specific data analysis language for users, direct and simple. They called it SEQUEL - structured English query language. With it, you can ask something from the database and get an answer.
The query looks like this:

Question:
Select Product, Price
From PriceList
Where Product = "Ice Cream"

Answer:
Ice cream | 140

The implementation of SQL in the Russian-language 1C looks exactly like the above.

When creating the language, the calculation was that accountants, economists would be able to write such questions on their own and get answers. Although the idea did not succeed (the language turned out to be overwhelming), it nonetheless turned out that SEQUEL, SQL ( pronounced as a sequel in the English-speaking environment) became the standard for working with databases among IT specialists. Since SQL knows how and allows:
• create tables, bases, structures
• insert and update data in these tables
• ask questions to tables
• the language is simple
• universal as it works in different databases.

And remains so to this day. Moreover, data storage and processing technologies that do not support this language are not becoming popular.

You can try the basics of this language (slightly modified) in Google Spreadsheets. Type = QUERY in the cell and follow the prompts.
Made on
Tilda