What are the supported operators and commands in FQL?

Question

I am trying to make a complete list, but the sources do not agree.

Here is what I have so far. Let me know if I am missing something, or if I misplaced something.

Main format: SELECT [fields] FROM [table] WHERE [conditions]

In the docs: now (), strlen (), substr () and strpos (), IN

Uncertain:

• AND
• OR
• LIMIT
• order_by
• OFFSET
• Anything else?

Also: Joins is definitely correct?

Answer 1

Supported features supported

:

me() now() rand() strlen(...) concat(...) substr(...) strpos(...) lower(...) upper(...) 

Supported Operators Supported

:

 AND, OR, NOT, IN, ><=, +-*/ 

OFFSET is part of LIMIT: offset, rowcount, i.e.

 LIMIT 5, 5 

ORDER BY is supported, DESC is also supported, ASC, SELECT * is not supported

EDIT: Joins are not supported, but you can do subqueries