title: Adding where clause after HANA placeholders in SQLAlchemy
body: <p>I'm trying to construct a query like this:</p>
  <pre><code>SELECT &quot;Inventory&quot;.item_id, &quot;Inventory&quot;.region
  FROM &quot;Inventory&quot; ('PLACEHOLDER' = ('$$P_Param$$', '0')) 
  WHERE &quot;Inventory&quot;.region = :region_1 
  </code></pre>
  <p>My select statement is adding the HANA placeholders at the end though:</p>
  <pre><code> select_stmt = select(
              inventory.item_id,
              inventory.region
          ).suffix_with(placeholders).where(inventory.region== 'USA')
  
  
  
  SELECT &quot;Inventory&quot;.item_id, &quot;Inventory&quot;.region
  FROM &quot;Inventory&quot; 
  WHERE &quot;Inventory&quot;.region = :region_1 ('PLACEHOLDER' = ('$$P_Param$$', '0')) 
  </code></pre>
  <p>How do I suffix the from clause with the placeholders and add the where clause afterwards?</p>
  <pre><code>class Inventory(Base):
      __tablename__ = 'Inventory'
      __table_args__ = {'schema': '_SYS_BIC'}
  
      date = Column(DateTime, primary_key=True)
      item_id = Column(Integer, primary_key=True)  
      region = Column(String)
      
      placeholder = &quot;('PLACEHOLDER' = ('$$P_Param$$', '0'))&quot;
  </code></pre>