after several hours of research I found this works perfectly fine
df = (spark.read.option(Constants.SERVER, "server_name.sql.azuresynapse.net").option(Constants.DATABASE, "db_name").synapsesql("select [Job Title] as JobTitle from dbo.TableName) )