Traditional BQL and SQL Equivalents
The traditional business query language (BQL) library defines the following SQL function
equivalents. Note that the use of the BQL equivalents may slightly differ from the use of the
corresponding SQL functions. For details on each BQL class, see the API Reference.
| SQL | Traditional BQL |
|---|---|
| Clauses | |
WHERE |
Where |
INNER JOIN |
InnerJoin |
LEFT JOIN |
LeftJoin |
RIGHT JOIN |
RightJoin |
FULL JOIN |
FullJoin |
CROSS JOIN |
CrossJoin |
ON |
On, On2 |
ORDER BY |
OrderBy |
ASC |
Asc |
DESC |
Desc |
GROUP BY |
Aggregate, GroupBy |
HAVING |
Having |
| Aggregation Functions | |
AVG |
Avg |
SUM |
Sum |
MIN |
Min |
MAX |
Max |
COUNT |
Count |
| Functions | |
ISNULL |
IsNull<Operand1, Operand2> |
NULLIF |
NullIf |
ROUND |
Round |
SUBSTRING |
Substring |
CONCAT |
Add |
RTRIM |
RTrim |
REPLACE |
Replace |
DATEDIFF |
DateDiff |
CASE |
Switch, Case |
| Arithmetic Operations | |
(Operand1 + Operand2) |
Add<Operand1, Operand2> |
(Operand1 - Operand2) |
Sub<Operand1, Operand2> |
(Operand1 * Operand2) |
Mult<Operand1, Operand2> |
(Operand1 / Operand2) |
Div<Operand1, Operand2> |
-Operand |
Minus<Operand> |
POWER(Operand1, Operand2) |
Power<Operand1, Operand2> |
| Comparisons | |
= |
Equal |
<> |
NotEqual |
> |
Greater |
< |
Less |
<= |
LessEqual |
<= |
GreaterEqual |
LIKE |
Like |
NOT LIKE |
NotLike |
BETWEEN |
Between |
NOT BETWEEN |
NotBetween |
IS NULL |
IsNull |
IS NOT NULL |
IsNotNull |
IN |
In, In2, In3 |
NOT IN |
NotIn, NotIn2 |
EXISTS |
Exists |
| Logical Operators | |
AND |
And, And2 |
OR |
Or, Or2 |
NOT |
Not, Not2 |
| Constants | |
NULL |
Null |
| Other constants | Now, Today, Tomorrow, True, False, Zero, StringEmpty, MaxDate |
| Full-Text Search Functions | |
FREETEXTTABLE |
FreeText |
CONTAINSTABLE |
Contains |