basic JPA question

[atomatom]

I'm doing my first project with JPA and I'm a bit confused about the limitations of the SmartGWT server. I have a Pro licence and it seems like lots of useful stuff requires a better licence.

For example, say I have these JPA classes

@Entity
class Dogs {
    @Id String name;
     String owner;
}

@Entity 
class Owner { 
    @Id String name;
} 
 
@Entity
class DogLoverClub { 
    @Id String memberId;
    String owner;
    String city;
}

If I want to filter Dogs whose owners are in the DogLoverClub in Chicago, can I do that using the JPA2DataSource without a Power or Enterprise licence? It seems this would be easy with extra where clauses, but I don't think I can do that with my Pro licence.

My alternative, it seems, is to write a DMI method to do this filtering on the server side. Or I guess I could explore database views.

What makes the most sense for this kind of query?

Thanks in advance for any pointers.