Query on tables

To get around not handling multi-level yaml data, I thought about the possibility of inserting tables that could be queried, getting mixed results from properties and tables.

Data1: Val1

# Table Title
| Name | Surname | Age |
| ---- | ---- | ---- |
| Alice | Black | 33 |
| Bob | Tycoon | 40 |

queried as (plausible syntax)

SELECT * FROM file-in-that-folder WHERE Property.Data1 is not null AND TableTtle.Age<40

I would also like to be able to define templates for tables, so that when I add a new row some data is pre-filled, such as syntax for links or formulas to calculate the field from other data on the same row.
Although calculated columns would be better defined only once to avoid redundancy.

1 Like