Query API Examples

[parkerl]

• Comparison operators: ==, !=, <=, >=, <, >
• Boolean operators: and, or, not
• Inclusion operator: in/2
• Search functions: like/2 and ilike/2
• Null check functions: is_nil/1
• Aggregates: count/1, avg/1, sum/1, min/1, max/1
• Date/time intervals: datetime_add/3, date_add/3
• General: fragment/1, field/2 and type/2