Add a view to an existing database in a separate page

I was wondering if this use case is possible:

I have a database in "Page A" with items in it.

I want to see a filtered version of that database in "Page B".

Is that possible?

Also I noticed that it's possible to use SQL to get blocks from other pages, etc. Is it possible to use SQL when playing with databases?

Thanks!