Is represented with the CCL language, originally with Coral8 which was acquired by Aleri. The language is SQL extension and belongs to the stream based language. The following example shows CCL query, this looks like SQL but has some additional clauses such as: STREAM and KEEP.

CREATE STREAM AutoDeliveryBid ;
INSERT INTO AutoDeliveryBid
SELECT CB.*,
  DS.RequestID AS DSRequestID,
  DS.DeliveryLatitude AS DeliveryLatitude,
  DS.DeliveryLongitude AS DeliveryLongitude,
  DS.RequiredPickUpTime AS RequiredPickUpTime,
  DS.RequiredDeliveryTime AS RequiredDeliveryTime,
  DS.Store AS DSStore
FROM DeliverySelection AS DS LEFT OUTER JOIN CurrentBids AS CB
ON DS.RequestID = CB.RequestID
WHERE DS.Automatic
ORDER BY Ts PER CB.RequestID  
LIMIT 1 ROWS PER CB.RequestID;
// If no bids, send an alert
INSERT INTO Alerts
SELECT DSStore, NULL, DSRequestID, "No auto bids for " + TO_STRING(DSRequestID)
FROM AutoDeliveryBid
WHERE RequestID IS NULL;
INSERT INTO Assignment
SELECT
  RequestID,
  Store,
  Driver,
  DeliveryLatitude,
  DeliveryLongitude,
  RequiredPickUpTime ,
  RequiredDeliveryTime
FROM AutoDeliveryBid
WHERE RequestID IS NOT NULL;

This link will allow you to download studio and server. Registration is required. You should also download Coral8 Engine Release and solution for FFD.