Using Mysql LOAD DATA LOCAL INFILE with drush
drush sql-query has a not-very-well documented option flag called --extra. This flag is used when connecting via the mysql command to add extra options to the command string. So a drush sql-query --extra '--local-infile' should enable Drush to connect the client with your needed option.