Query Builder

Build optimized and safe SQL queries for Protheus tables. Automatically includes mandatory filters (D_E_L_E_T_, branch), suggests appropriate indexes from SIX patterns, generates both Embedded SQL (preferring FWExecStatement) and Workarea (DBSelectArea/DBSeek) versions, and warns about common Protheus SQL pitfalls. Use when user says 'build query', 'SQL for Protheus table', 'FWExecStatement', 'TCQuery', 'Workarea vs SQL'.

tbc-servicos Updated 4 repo stars

File contents

tbc-servicos/dataagile-agent-kit commit 3336b140bc

Frequently asked questions

npx get-skill add tbc-servicos/query-builder