Jamie Balfour

Welcome to my personal website.

Find out more about me, my personal projects, reviews, courses and much more here.

ZPE Expression Query Language - ZEQL

ZEQL, pronounced as zequel - like sequel, is very similar to SQL, but it can be used on lists, maps, records and database queries. There are also plans for ZEQL to support conversion to SQL. 

Whilst ZEQL is not finished yet, and really nowhere near finished, it's started to take shape.

Where ZEQL comes in handy is speed; it's considerably faster than using a loop to iterate a list, as it compiles directly to native code. 

YASS
$a_words = from $word in $words
  where string_contains($word, "a")
  select $word

In addition to this syntax, it supports chained functions, commonly known as fluent interface method chaining, including where (has existed for a while now), select and order_by.

YASS
$a_words = $words.where($word => string_contains($word, "a")).select($word => $word)
Comments

There are no comments on this page.

New comment

Comments are welcome and encouraged, including disagreement and critique. However, this is not a space for abuse. Disagreement is welcome; personal attacks, harassment, or hate will be removed instantly. This site reflects personal opinions, not universal truths. If you can’t distinguish between the two, this probably isn’t the place for you. The system temporarily stores IP addresses and browser user agents for the purposes of spam prevention, moderation, and safeguarding. This data is automatically removed after fourteen days. Your email address is stored so that replies can be sent to your email address.

Comments powered by BalfComment

Powered by DASH 2.0