Hi @Retired_mod, Thanks for your response. 
I'm looking for a utility or an automated way of translating any generic SQL into PySpark DataFrame code.

So, the translate function should look like below:

def translate(input_sql):
    # translate/convert it into pyspark dataframe code
    return pyspark_code

Please suggest