Right now it does not use any special feature though some of the syntax might be a bit different in PostgreSQL and in SQLite.
In the near future I am quite sure we will use various Pg specific features (e.g. Pg can hold arrays in a single database field while I think SQLite cannot).