SQLP 2.0 and SQLEP 1.3 Tutorial

###Introduction The new features of the SQL Processor (SQLP) version 2.0.0 and the SQL Processor Eclipse Plugin (SQLEP) version 1.3.0 are

• the unified grammar
• the simplified terminology

Unfortunately, the side effect is that the backward compatibility is broken.

###Control directives The control directives for POJOs and DB tables identification have been renamed

• in for dynamic input values identification - it references POJO class
• inx for dynamic input values identification - it references POJO entity
• out for output values identification - it references POJO class
• outx for output values identification - it references POJO entity
• col for database tables/columns identification

This can be seen in the following snippet in statements.qry

GET_BANK_ACCOUNT(CRUD,final=,inx=BankAccount,outx=BankAccount,col=billingDetails=b,col=subscriber=s)=
  select %b.BA_ACCOUNT @baAccount, %b.ID @id(id), %b.SUBSCRIBER @subscriber.id(id), %b.TYPE @type, %b.VERSION @version
         {? :subscriber(call=toInit) | , %s.LIBRARY @subscriber.library.id, %s.CONTACT @subscriber.contact.id, %s.NAME @subscriber.name, %s.VERSION @subscriber.version }
  from %%BILLING_DETAILS b
  {? :subscriber(call=toInit) | left join %%SUBSCRIBER s on %b.SUBSCRIBER = %s.ID }
  {= where
    {& %b.BA_ACCOUNT = :baAccount }
    {& %b.ID = :id }
    {& %b.SUBSCRIBER = :subscriber.id }
    {& %b.TYPE = :type }
  }
;

Just to remember - TODO