SQLPage snippet generation

[YunusMechery]

Since SQL autocompletion and SQLPage components auto completion conflicts always in code editors, I developed below on-demand SQLPage snippet generation using Google Sheets. May be useful to some people.

1. Keep open below google sheet whenever you code in SQLPage
2. https://docs.google.com/spreadsheets/d/1-50TwZ06eqxBijWHIC9iFzao6Rk13vgPUVoiD3zld5U/edit?gid=0#gid=0
3. set component name in B1 cell as and when required
4. copy paste the generated component snippet from cell I2
5. fill with your values
6. use line comment unused fields
7. Googel sheet uses below formula, hence it will cover future added component properties automatically.
   =IMPORTHTML("https://sql-page.com/component.sql?component=" & B1,"table",1)
8. Top level parms and Row level parms snippets are separate tabs.
9. Component names are not dynamic. I will add new components as and when new components are added in SQLPage

[lovasoa]

If you need to extract the source, structured data from the official site is here: https://github.com/sqlpage/SQLPage/tree/main/examples/official-site

it can be extracted as a sqlite db:
docs.zip

[YunusMechery]

Not able to extract the list of component names from https://sql-page.com/documentation.sql, using IMPORTHTML() in Google Sheets, because its neither list nor a table.