I faced the same problem and did not want to turn of SQL inspection everywhere, just in Markdown files.

I created a custom scope for markdown files. Click on SQL under Inspections and there you can select/create/edit scopes and their respective behaviors

I used this file-pattern:

file[*]:*/*.md