What are the supported operators and commands in FQL?

Question

I'm trying to compile a complete list but the sources don't agree.

Here's what I've got so far. Let me know if I'm missing anything, or if I've put anything in incorrectly.

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

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

Unsure:

1. AND
2. OR
3. LIMIT
4. ORDER_BY
5. OFFSET
6. Anything else?

Also: Joins are definitely out right?

Answer 1

functions supported:

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

operators supported:

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

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

LIMIT 5, 5  

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

EDIT: joins not supported but you can do subqueries