mORMot Open Source

Greetings,

I am trying to figure out how the ORM part of the framework is working, but no luck until now, so I decided to give it a try here.
Lets say I have a "model" which should reflect a row in the table "city" of the database.

City = class(TSQLRecord)

And some DB connection properties (in my case ZEOS)

Properties := TSQLDBZEOSConnectionProperties.Create(/*connection string*/);

How I can:
# retrieve in local variable of type City the record with ID 1
# retrieve in local variable of type City the record with name = 'new york'
# retrieve in local variable of type Array[City] where ID between 10 and 15

And lets assume we have a BELONGS_TO relation to another "model" country via country_id FK:
How I can:
# retrieve in local variable of type Array[City] where country.name = 'us';
# eager load in load variable of type Array[City] with their corresponding Country "models"
# create new record in "country" table with 2 related records in "city" table at once. (not single insert, but for example in other framework of another language i would use countryModel.Save( with related );

Thanks in advance!
Best Regards,
Daniel Tsviatkov