BlockQL

BlockQL is a block-based programming language specializing in queries and spreadsheets. It is my first attempt at a block-based programming language. It is implemented in Rust.

Queries can be written in:

• C
• CodeQL
• D
• Java
• Python
• R
• Rust
• VBA
• More languages coming soon

Spreadsheets can also be imported in the following formats:

• *.dbf
• *.dif
• *.fods
• *.ods
• *.ots
• *.slk
• *.uos
• *.xlsx
• *.xls
• More formats coming soon

File format

BlockQL has 2 file formats:

• *.bloql (project file, shortened form of BlockQL, official pronunciation is block L)
• *.bloqs (spreadsheet file, official pronunciation is blocks)

Syntax

Hello World

"Hello World"

Basic query

-- DEF Coin = integer(250)
import shop
usr: "ANNA" has "Banana"
usr: "ABBY" has "Coin{12}"
usr: "SHOP" has "Banana{tc:250{Coin}}"
-- tc: Total cost
join "ABBY","SHOP"
return "SHOP" getResponse "Purchase"
-- Should return:
"SHOP: User ABBY cannot buy the banana, ABBY needs 238 more coins"

Note shop is a demo library that has noty yet been created.

Comments

-- Single line comment
-=-
Block Comment
-=-

Needs more planning, language might be rewritten.

File version: 1 (2023, Tuesday, March 28th at 7:34 pm PST)