r - Problems with read.csv.sql when data has commas -

i'm trying read .csv file following:

"name", "address"
"me", "my address, city, state"

when try

read.csv.sql(file = "myfile.csv", sql = "select * file") 

i error:

error in .local(conn, name, value, ...) :      rs_sqlite_import: myfile.csv line 2 expected 2 columns of data found 4 

it seems read.csv.sql unable recognize address record in .csv file 1 observation (rather 3, given commas). there way avoid problem? looked @ file read.csv.sql, doesn't seem there's option fixes issue.

in reality, have large file , want read subset of columns. if there tool available within r, i'm happy use instead of read.csv.sql.