Welcome to Anvil @jordaddy1 !
In Anvil, the way to query data tables is with the search method with the column name(s) being queried as the keyword argument(s):
app_tables.my_table.search()
with query functions as outlined in this blog post that are arguments in the search method:
For filtering on the UI side, this is a relevant post from yesterday you might also be interested in: