[R] Custom Command to Generate SQL

[Alex Restrepo]

Hi:

I would like to create a custom command in R which generates SQL, which is 
then processed via RODBC.

For example, the user would type:

        retrieve firstName('JOHN') middlleName('WILLIAMS') lastName('FORD')

This would generate the following SQL which would then be processed by 
RODBC:

Select *
  from people
  where firstName = 'JOHN' and
            middleName = 'WILLIAMS' and
            lastName     = 'FORD'

Does anyone have a recommendation?  Any ideas would be greatly appreciated.

Alex