How to escape field name in orientdb

Question

I'm having a class with fields like from and to in an orientdb database.

How do I execute a query that select the from and to fields?

I tried select [from] from Activity but it is complaining about [.

Answer 1

You have to disable the strictSql using this command:

ALTER DATABASE custom strictSql=false

and then you have to use the backtick:

SELECT `from` FROM Activity

Answer 2

FROM and TO are reserved words. So you could just change the name or backtick them. Example:

select `from` from Activity