mattjcamp/coderr

A super-simple SQL code generator for lazy R programmers

👋 Hi, I’m Matt

👀 I’m interested in UFOs, Coding, Data, and Writing

🌱 Working on rebooting my site How to Make iPhone Apps that I started in 2009

💞️ Interested in a bunch of other things like: sourdough bread baking, cooking, FPV drones, and taking long hikes in the woods where I solve the world's problems

📫 Reach me at

• [email protected]
• on Twitter @mattjcamp
• on my website https://mattjcamp.com

coderr's Issues

Add Select Col Verb

add verb to cover this instance:

code_sql_select(select.cols = c("*",
"case when us = 'n' then 'international'
when sector = 'np' and us = 'y' then 'us - non-public'
when sector = 'p' and us = 'y' then 'us - public'
else null
end as sector_2"))

Add Insert Into Verb

Add Create Table Verb

code_sql_select filter broken

code_sql_select filter doesn't write the WHERE statement correctly. The WHERE keyword and connection AND keywords do not appear.