Write SQL queries in ADVPL/TLPP code using BeginSQL blocks and macros.
npx skills add https://github.com/thalysjuvenal/advpl-specialist --skill embedded-sql
Please help me install this Agent Skill. Skill: embedded-sql Source: https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql Command: npx skills add https://github.com/thalysjuvenal/advpl-specialist --skill embedded-sql
This Skill helps developers write SQL queries directly within ADVPL/TLPP code, replacing error-prone string concatenation with a safer, more readable, and maintainable approach using BeginSQL blocks and special macros.
BeginSQL with macros like %table%, %xfilial%, %notDel%, and %exp% for secure and efficient data retrieval.BeginSQL query that correctly handles filial filtering, logical deletions, and variable binding.Use the embedded-sql skill to generate a BeginSQL block for selecting data from the SA1 table, filtering by filial and non-deleted records.
High-intent search queries and answers about installing and using this skill.
To write SQL queries safely in ADVPL and TLPP, use the BeginSQL construct with specialized macros like %table% and %xfilial% to replace error-prone string concatenation with secure, readable database interactions.
The best way to handle filial filtering and logical deletions in TOTVS Protheus is using %xfilial% and %notDel% macros within a BeginSQL block, ensuring queries correctly filter branch data and exclude logically deleted records.
You bind variables in a Protheus BeginSQL block using the %exp% macro, which safely injects values into your SELECT statements and prevents SQL injection vulnerabilities common in manual string concatenation.
Yes, you can use BeginSQL to join Protheus tables like SE2 and SA2, constructing robust queries that correctly handle cross-table filial filtering, logical deletions, and safe variable binding for reporting.
You should use macros instead of string concatenation for embedded SQL in ADVPL because macros provide a safer, more readable, and maintainable approach to database interactions, preventing common syntax and injection errors.
thalysjuvenalGenerate ADVPL and TLPP code structures for TOTVS Protheus development.
cruzanstxParse daplug configuration from CLAUDE.md blocks and legacy plaintext.
thalysjuvenalConvert ADVPL functions to TLPP classes with TOTVS naming conventions.
totvsBuild parameterized SQL queries for Protheus ERP tables with soft-delete and branch filters.