Spark now supports the ilike (case insensitive LIKE) statement since version 3.3.0.

You should be able to use your command:

results = spark.sql("select * from df_sql_view where name ILIKE '%i%'")