Skip to content
Perform fast json queries
In a short time, without any effort.
Start now using Teta >
Get started
Fetch docs in collection
It returns all the docs in "CollectionName" collection.
In SQL: SELECT * FROM CollectionName
Select a field
It returns only fields where name is equal to "_name" from all the docs
Equivalent in SQL: SELECT _name FROM CollectionName
With condition
Returns all documents that match the condition
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value"
OR condition
Returns all documents that match the conditions
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2"
Sort docs
Returns all documents sorted by field name. Use -1 or 1 to choose the order.
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2" ORDER BY _name ASC
Limit docs
Returns all documents limited by a number.
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2" ORDER BY _name ASC LIMIT 10
From multi collections
Get documents from multi collections
Equivalent in SQL: SELECT * FROM CollectionName1, CollectionName2
Date conditions
Fetch docs by a date condition.
You can combine GT, LT, DateSub, and DateAdd.
Equivalent in SQL: SELECT * FROM CollectionName WHERE created_at > now() - interval '1 month'
Start using Ayaya.
And perform custom queries on your back-end effortlessly.
Start now >