Teta

Perform fast json queries

In a short time, without any effort.

Get started

Fetch docs in collection

It returns all the docs in "CollectionName" collection.

				
					MATCH name EQ CollectionName;
IN docs;
				
			

In SQL: SELECT * FROM CollectionName

Select a field

It returns only fields where name is equal to "_name" from all the docs

				
					MATCH name EQ CollectionName;
IN docs;
GET _name;
				
			

Equivalent in SQL: SELECT _name FROM CollectionName

With condition

Returns all documents that match the condition

				
					MATCH name EQ CollectionName;
IN docs;
MATCH _name = 'value';
				
			

Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value"

OR condition

Returns all documents that match the conditions

				
					MATCH name EQ CollectionName;
IN docs;
MATCHOR _name EQ 'value' _name LIKE /value2/;
				
			

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.

				
					MATCH name EQ CollectionName;
IN docs;
MATCHOR _name EQ 'value' _name LIKE /value2/;
SORT _name 1;
				
			

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.

				
					MATCH name EQ CollectionName;
IN docs;
MATCHOR _name EQ 'value' _name LIKE /value2/;
SORT _name 1;
LIMIT 10;
				
			

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

				
					MATCHOR name EQ CollectionName1 name EQ CollectionName2;
IN docs;
				
			

Equivalent in SQL: SELECT * FROM CollectionName1, CollectionName2

Date conditions

Fetch docs by a date condition.

You can combine GT, LT, DateSub, and DateAdd.

				
					MATCHOR name EQ CollectionName;
IN docs;
MATCH created_at GT DATESUB($now $week);
				
			

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.