products-dynamic.jigx

type: datasource.sqlite
options:
  provider: DATA_PROVIDER_DYNAMIC
  entities:
    - entity: default/products
  query: |
    SELECT
      id,
      '$.title',
      '$.uri',
      '$.tag',
      '$.price',
      '$.category',
      '$.discount'
    FROM [default/products]
    WHERE '$.category' = "product"