Take JPG store as an example. When someone lists an NFT for sale there, or when someone buys an NFT there, a smart contract governs that transaction.

Can sql queries against the db-sync generated blockchain data "see" that? I'd like to write sql queries against the db-sync data that show the most recent transaction involving a particular smart contract, but I'm not sure what to query for...

UPDATE:

Here is a call to opencnft's free api which allows me to know the most recent transactions involving a particular NFT policy, sorted by date. If I want to simple replicate that by using sql queries against db-sync...?

https://api.opencnft.io/1/#/Policy/PublicController_getPolicyTx