python – Azure blob query documentation

Recently, I have been looking for a way to query csv data files in blob storage with python.

I currently have a naive solution which pulls down the file and then filters out uneeded rows, but I recently came across this Azure github example repo as well as this stack overflow question, which references these official azure sdk docs.

This looks like what I want. My questions are:

1. What SQL variant is it using? And where can I find it’s doc’s and supported features?
2. Does it support querying csv files (or text files in general) line by line? I would like to be able to write a query like select line from file where line contains {search_string}. Does this blob query have that capability?