---
title: Tooling API Objects
description: "SQL-Sales supports querying a number of Tooling api objects which mandate a particular way of querying (the \"a filter on a reified column is required\") Salesforce constraints as these objects are essentially virtual. | Object Name | Field Name |…"
url: "https://sql-sales.com/docs/tooling-api-objects/"
updated: "2026-08-31"
category: Metadata
---

# Tooling API Objects

SQL-Sales supports querying a number of Tooling api objects which mandate a particular way of querying (the "a filter on a reified column is required") Salesforce constraints as these objects are essentially virtual.

| Object Name | Field Name | Where Clause / Notes |
| --- | --- | --- |
| PicklistValueInfo | DurableId | WHERE DurableId = 'Account.Industry.Consulting' |
| PicklistValueInfo | EntityParticleId | WHERE EntityParticleId = 'Account.Industry' |
| FieldDefinition | DurableId | WHERE DurableId = 'Account.Name' |
| FieldDefinition | EntityDefinitionId | WHERE EntityDefinitionId = 'Account' |
| FieldDefinition | EntityDefinitionId | WHERE EntityDefinitionId in ('Account','Contact') |
| FieldDefinition | remote example | WHERE EntityDefinition.QualifiedApiName = 'Account' |
| RelationshipDomain | DurableId | not queryable |
| RelationshipDomain | ChildSobjectId | WHERE ChildSobjectId = 'Account' |
| RelationshipDomain | FieldId | WHERE FieldId = 'Account.Parent' |
| RelationshipDomain | ParentSobjectId | WHERE ParentSobjectId = 'Account' |
| RelationshipDomain | RelationshipInfoId | not queryable |
| RelationshipInfo | ChildSobjectId | WHERE ChildSobjectId = 'Account' |
| RelationshipInfo | FieldId | WHERE FieldId = 'Account.Owner' |
| RelationshipInfo | DurableId | not queryable |
| EntityParticle | FieldDefinitionId | WHERE FieldDefinitionId = 'Account.AccountSource' |
| EntityParticle | EntityDefinitionId | WHERE EntityDefinitionId = 'Account' |
| EntityParticle | DurableId | WHERE DurableId = 'Account.AccountSource' |
| RelatedListDefinition | ParentEntityDefinitionId | WHERE ParentEntityDefinitionId = 'Account' |
| RelatedListDefinition | DurableId | WHERE DurableId = 'Account.RelatedActivityList' |
| RelatedListDefinition | remote example | WHERE ParentEntityDefinition.QualifiedApiName = 'Account' |
| RelatedListColumnDefinition | RelatedListDefinitionId | WHERE RelatedListDefinitionId = 'Account.RelatedActivityList' |
| RelatedListColumnDefinition | DurableId | WHERE DurableId = 'Account.RelatedActivityList.OWNER_ROLE' |
| Publisher | NamespacePrefix | WHERE NamespacePrefix = 'SQLSales' |
|  |  |  |
| PackageLicense.NamespacePrefix |  |  |
| Publisher | DurableId | WHERE DurableId = 'SQLSales' |
| UserEntityAccess | UserId | WHERE UserId = '005QH0000013r5dYAA' |
|  |  |  |
| User.Id |  |  |
| UserEntityAccess | DurableId | WHERE DurableId = 'ProcessInstance.005QH0000013r5dYAA' |
| UserFieldAccess | DurableId | WHERE DurableId = 'Account.Name.005QH0000013r5dYAA' |
|  |  |  |
| User.Id |  |  |
| TabDefinition | DurableId | WHERE DurableId = 'Account' |
| SiteDetail | DurableId |  |
| SearchLayout | DurableId | WHERE DurableId = 'Account.SearchResult' |
| SearchLayout | EntityDefinitionId | WHERE EntityDefinitionId = 'Account' |
| ColorDefinition | DurableId | WHERE DurableId = 'Account-theme3' |
| ColorDefinition | TabDefinitionId | WHERE TabDefinitionId = 'Account' |
| OwnerChangeOptionInfo | DurableId | WHERE DurableId = 'Account.SendEmail' |
| OwnerChangeOptionInfo | EntityDefinitionId | WHERE EntityDefinitionId = 'Account' |
| FlowVersionView | FlowDefinitionViewId | WHERE FlowDefinitionViewId = 'industries_fsc__CreateSlackAccChannel' |
|  |  |  |
| exec ss_Replica 'xxx','FlowDefinitionView','subset(DurableId)','WHERE DurableId like ''%a%''' |  |  |
| pass FlowDefinitionView.DurableId as the FlowDefinitionViewId |  |  |
| FlowVersionView | DurableId | WHERE DurableId = 'industries_fsc__CreateSlackAccChannel-1' |
| FlowVariableView | FlowVersionViewId | WHERE FlowVersionViewId = 'industries_fsc__CreateSlackAccChannel-1' |
|  |  |  |
| FlowVersionView.DurableId = FlowVariableView.FlowVersionViewId |  |  |
| FlowVariableView | DurableId | WHERE DurableId = 'industries_fsc__CreateSlackAccChannel-1.recordId' |
| IconDefinition | TabDefinitionId | WHERE TabDefinitionId = 'Account' |
| IconDefinition | DurableId | WHERE DurableId = 'Account-theme3-16' |
| ApexTypeImplementor | InterfaceName |  |
| ApexTypeImplementor | DurableId |  |
| AppTabMember | TabDefinitionId |  |
| AppTabMember | AppDefinitionId | WHERE AppDefinitionId = '06mQH000000iazzYAA' |
|  |  |  |
| AppTabMember.AppDefinitionId = AppDefinition.Id |  |  |
| AppTabMember | DurableId | WHERE DurableId = '06mQH000000iazzYAA-Account' |
| FlowTestView | FlowDefinitionViewId | WHERE FlowDefinitionViewId = 'industries_fsc__CreateSlackAccChannel' |
|  |  |  |
| exec ss_Replica 'xxx','FlowDefinitionView','subset(DurableId)','WHERE DurableId like ''%a%''' |  |  |
| pass FlowDefinitionView.DurableId as the FlowDefinitionViewId |  |  |
| FlowTestView | DurableId |  |