WHERE or.id=::id:: AND o.orderid=::order.id:: AND o.clientid=::order.client.id::

var params = ~/(::([a-zA-Z.]+)::)/gm;
var param : String = where;
var list = new List<String>();
while(params.match(param)) {
	list.add(params.matched(2));
	var x = params.matchedPos();
	param = param.substr(x.pos+x.len);
}