http://blog.takuyan.com/blog/2012/08/22/active-record-for-titanium/

article.coffee

#
# lib/models/article.coffee
# => Resources/models/article.js
#
TiActiveRecord = require 'lib/TiActiveRecord'

class Article extends TiActiveRecord

  @dbName = 'myapp'
  @tableName = 'articles'
  # @remove_auto_increment = true # If you do not need 'AUTOINCREMENT' to id, please set to true
  # @remove_primary_key = true    # If you do not need 'PRIMARY KEY' to id, please set to true
  @properties =
    uid: 'integer'
    title: 'text'
    body: 'text'
    image_url: 'text'
    image_name: 'text'
    pv: 'integer'

Article.init()

module.exports = Article