title: How to handle database view using Symfony?
body: <p>Anybody have idea about how to handle database view in PHP symfony1.4?</p>
  
  <p>I have created a view 'ABC' manually in DB. 
  Now, I want to select records from that view 'ABC' with adding where clause in query.
  If possible give example.</p>
  
  <p>EDIT:</p>
  
  <p>My schema is:</p>
  
  <pre><code>Product:
    columns:
      name:             { type: string(127), notnull: true }
      launch_date:      { type: date }
      price:            { type: integer }
      status_id:        { type: integer }
  
  ProductLocation :
      product_id:       { type: integer }
      name:             { type: string(50) }
      launch_date:      { type: date }
    relations:
      Product:          {onDelete: RESTRICT, local: product_id, foreign: id, foreignAlias: "Products" } 
  </code></pre>
  
  <p>I want to create view for union of two tables. 
  Thanks</p>