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.