Yes, it can be done - SQL doesn't care what data columns contain, as long as you store it in the right type of column.
PDF files are either 8-bit binary files or 7-bit ASCII text files, so the safest thing to do is store them in a VARBINARY column and pass the data through via a parameterised query, along with the filename.
You can then retrieve it with an LIKE query on the filename:
SELECT ... WHERE FileNameColumn LIKE '%March 2020%'
will return any filename with the text "March 2020" in it, for example. Again - obviously - a parameterised query is mandatory!
When you do that, you have the data in a byte array, and can display in whatever you need to.