Examples of using the Model class?

[eluser]Colin Williams[/eluser]
Derek's example made, what, 2 queries in total. I find that as the complexity of the app grows, it's nice to have the model class as a nice separation and abstraction of common queries. You are right, CI models don't do ORM, define schemas, or anything like that by default. CakePHP or Symfony might do something like that, if you care for the additional overhead of those frameworks.