SELECT json FROM DestinyInventoryItemDefinition WHERE (json_extract(json, '$.displayProperties.name') = 'Paradoxical Impression');
{ - "displayProperties": {...},
- "tooltipNotifications": [],
- "collectibleHash": 2040505656,
- "secondaryIcon": "/common/destiny2_content/icons/2d0a3f27073992dc947f5d38582f2d17.jpg",
- "secondaryOverlay": "/common/destiny2_content/icons/6f5f48e8bed6f7212de70761159acb1a.png",
- "secondarySpecial": "/common/destiny2_content/icons/d8ebe7efef127c66cda0f33783aa3905.jpg",
- "backgroundColor": {...},
- "itemTypeDisplayName": "Emblem",
- "flavorText": "",
- "uiItemDisplayStyle": "",
- "itemTypeAndTierDisplayName": "Legendary Emblem",
- "displaySource": "",
- "tooltipStyle": "record",
- "action": {...},
- "inventory": {...},
- "stats": {...},
- "equippingBlock": {...},
- "preview": {...},
- "metrics": {...},
- "acquireRewardSiteHash": 0,
- "acquireUnlockHash": 0,
- "investmentStats": [],
- "perks": [],
- "allowActions": true,
- "doesPostmasterPullHaveSideEffects": false,
- "nonTransferrable": true,
- "itemCategoryHashes": [...],
- "specialItemType": 0,
- "itemType": 14,
- "itemSubType": 0,
- "classType": 3,
- "breakerType": 0,
- "equippable": true,
- "defaultDamageType": 0,
- "isWrapper": false,
- "traitIds": [...],
- "traitHashes": [...],
- "hash": 3063212166,
- "index": 26940,
- "redacted": false,
- "blacklisted": false
}