I have R code which submits SQL statements to a database server. Since the SQL is rather complex, I want to put it into a separate code block in order to have proper formatting, syntax highlighting, etc:
#+name: long-sql
#+begin_src sql
select *
from many, tables
where
complex_condition1 = 1,
complex_condition2 = 2
#+end_src
* Load the data to R session
#+begin_src R :session *R* :noweb yes
result <- submit_query('<<long-sql>>')
#+end_src
Unfortunately, the R block doesn't work. When I open the file generated by Babel, I see this:
result <- submit_query('select *
result <- submit_query('from many, tables
etc
instead of the one R submit_query call with my SQL statement as an argument. Is there anything I can do to achieve that?
Thanks
Alex