tools-only Credits & Acknowledgments
This skill was built upon the collective wisdom of the Salesforce developer community. We gratefully acknowledge the following authors and resources whose ideas, patterns, and best practices have shaped this skill.
Authors & Contributors
James Simone
Key contributions:
- Repository Pattern for SOQL abstraction
- Strongly-typed Query Builder concepts
- Testing-focused query design
- Field dependency management
Referenced articles:
Beyond the Cloud (Piotr Gajek)
Key contributions:
- Selector Layer architecture concepts
- Query composition over inheritance
- FLS and sharing mode best practices
- Query mocking for unit tests
Referenced articles:
- Why You Need a Selector Layer
- SOQL Lib concepts (patterns only, not the library)
- Salesforce Mock in Apex Tests
Apex Hours (Amit Chaudhary)
Key contributions:
- Governor limits guidance
- SOQL & SOSL performance tuning
- Bulkification patterns
- Anti-pattern documentation
Referenced articles:
- SOQL & SOSL Performance Tuning
- Governor Limits in Salesforce
- How to Resolve Too many SOQL Queries 101
- Bulkification of Apex Triggers
Medium Contributors
Saurabh Samir
Official Salesforce Resources
- Query Optimization Guide: help.salesforce.com - Improve SOQL Query Performance
- Developer Guide: SOQL & SOSL Reference
- Trailhead: Apex & .NET Basics - Efficient Database Queries
Key Patterns Integrated
| Pattern | Source | Integration |
|---|---|---|
| Selector Layer | Beyond the Cloud | docs/selector-patterns.md |
| Bulkification | Apex Hours, Medium | templates/bulkified-query-pattern.cls |
| Anti-patterns | Multiple sources | docs/anti-patterns.md |
| Query Plan Analysis | Salesforce Docs | SKILL.md, optimization-patterns.soql |
Philosophy
This skill integrates concepts and patterns from community resources, not specific libraries as dependencies. The goal is to teach Apex developers how to write efficient, maintainable SOQL using vanilla Apex patterns that don't require external package installation.
If we've missed anyone whose work influenced this skill, please let us know so we can add proper attribution.