Expand description
Built-in SQL functions and operators supported by the easy-sql macros.
The items below are recognized by query! and query_lazy!
across all drivers. Individual drivers opt into support by implementing the corresponding
marker traits (typically via impl_supports_fn,
impl_supports_fn_any, or manual impls).
For custom SQL functions not listed here, use
custom_sql_function!.
§Built-in SQL functions
- Aggregates:
COUNT→SupportsCountSUM→SupportsSumAVG→SupportsAvgMIN→SupportsMinMAX→SupportsMax
- Text:
CONCAT→SupportsConcatUPPER→SupportsUpperLOWER→SupportsLowerLENGTH→SupportsLengthTRIM→SupportsTrimSUBSTRING→SupportsSubstringSUBSTR→SupportsSubstr
- Null handling:
COALESCE→SupportsCoalesceNULLIF→SupportsNullifIFNULL→SupportsIfnull
- Date/time:
NOW→SupportsNowDATE→SupportsDateTIME→SupportsTimeDATETIME→SupportsDatetimeCURRENT_TIMESTAMP→SupportsCurrentTimestampCURRENT_DATE→SupportsCurrentDateCURRENT_TIME→SupportsCurrentTime
- Math:
ABS→SupportsAbsROUND→SupportsRoundCEIL→SupportsCeilCEILING→SupportsCeilingFLOOR→SupportsFloorPOWER→SupportsPowerPOW→SupportsPowSQRT→SupportsSqrtMOD→SupportsMod
- Misc:
CAST→SupportsCastDISTINCT→SupportsDistinct
§Built-in operators
- Boolean logic:
AND→SupportsAndOR→SupportsOr
- Arithmetic:
+→SupportsAdd-→SupportsSub*→SupportsMul/→SupportsDiv%→SupportsModOperator
- String/json:
||→SupportsConcatOperator->→SupportsJsonExtract->>→SupportsJsonExtractText
- Bitwise:
&→SupportsBitAnd|→SupportsBitOr<<→SupportsBitShiftLeft>>→SupportsBitShiftRight
- Comparison:
=→SupportsEqual!=→SupportsNotEqual>→SupportsGreaterThan>=→SupportsGreaterThanOrEqual<→SupportsLessThan<=→SupportsLessThanOrEqualLIKE→SupportsLikeIS NULL→SupportsIsNullIS NOT NULL→SupportsIsNotNullIN→SupportsInBETWEEN→SupportsBetween