Doctrine provides many ways for record retrieval. The fastest ways for retrieving existing records are the finder methods provided by Doctrine_Table. If you need to use more complex queries take a look at
DQL API and Doctrine_Connection::query method.
