Can we use the Direct Query method, to create a Personal Gateway to connect to the database so that we can see data in the reports ?

Yes, we need to install the "normal" gateway (Enterprise), instead of a personal gateway. Enterprise gateway is the one we can set up and view reports in the organization level for multiple accounts, whereas Personal gateway is tied directly to one account.