In terms of the API, there isn't a current way to interact with PDTs. We do have an i__looker Explore, from the internal database, which should be able to get you the data you're looking for. Paste in your domain into the url listed below to take a look and explore! We do not currently support SQL Runner in i__looker, but I will pass on all of this information to our product team. Thanks, @Vinod_Patil!