BUG: Allow read_sql_table to read from views
Solves #10750 

Follow-up from #10771

'read_sql_table'  will now allow reading from views. 

Added also a note in whatsnew and a unit test to check the behaviour.

Thanks!
