Table 2 The definition of operations of the SQL-like query.
From: A repository for the publication and sharing of heterogeneous materials data
Operator type | Operator name | object | note |
|---|---|---|---|
Arithmetic operator | null | all | is null |
any | is not null | ||
eq | String, Number | be equal to … | |
neq | not be equal to … | ||
start_with | String, Choice | prefix with … | |
nstarts_with | not prefix with … | ||
ends_with | suffix with … | ||
nends_with | not suffix with … | ||
contains | contain string … | ||
ncontains | not contain string … | ||
eq | Number | be equal to … | |
neq | not be equal to … | ||
gt | more than … | ||
lte | less than or equal to … | ||
lt | less than … | ||
gte | more than or equal to … | ||
Quantifier operator | all satisfy | Table, Array | all rows that satisfy … |
exist none that satisfies | There is no row exists that satisfies … | ||
exist one that satisfies | There is a row exists that satisfies… | ||
exist k-row that satisfies | There is k-row exists that satisfies… | ||
Logic operator | and | — | When the query is satisfied at the same time, the query result is returned |
or | When one of the queries is satisfied, the query result is returned |
