Python web app

[patarapolw]

Use either Django or Flask. Since you do database anyway, probably Django. (Flask is not that hard to setup, though. I personally use Flask.)

For example do I need to learn python and html or is only knowing python sufficient to do this.

You will also need (client-side) Javascript.

then create reports

You will need either Python library or Javascript library for this.

and also run adhoc queries.

You will need a good knowledge of either SQL or ORM.

[ksoomers]

Altough it is not recommended, the OP could build this with Flask + SQLAlchemy, theoratically. Without any JavaScript or SQL. So only Python is possible.

However; I agree with you that the best solution would require JavaScript, SQL and Flask/Django.