search

loreabad6 / masters-thesis-geotech

BNA-EU: Advances of my master thesis for the Erasmus Mundus Masters of Geospatial Technologies
3 stars 1 forks source link

Update SQL syntax #5

Open loreabad6 opened 2 years ago

loreabad6 commented 2 years ago

I am not sure when this changed, but currently running SQL chunks in R only allow one statement at a time. This is to avoid SQL injection. MANY chunks in BNA-Europe.Rmd have really long multiple SQL lines, so an efficient way to migrate this should be thought of.

loreabad6 commented 2 years ago

Maybe some tips here: https://sciencificity-blog.netlify.app/posts/2021-03-27-sql-in-rmarkdown/