Issues running count queries against MS SQL

[yruslan]

Describe the bug

A regression was introduced in 1.9.5.

The query that looks like this:

SELECT COUNT(*) FROM (SELECT * FROM COMPANY)

does not compile. Need a mandatory alias:

SELECT COUNT(*) FROM (SELECT * FROM COMPANY) query

Code and/or configuration snippet that caused the issue

pramen {
}

Expected behavior

A clear and concise description of what you expected to happen.

Context

• Pramen/pramen-py version:
• Spark version:
• Scala/Python version:
• Operating system: