[Feature request] parse the content of outline level 0

[jarofromel]

Hello, some of my org files have some content before the first headline:

#+title:       file title      
#+date:       [2024-09-12 Thu 17:19]
#+subtitle: file subtitle with short description

summary of the file, notes/todos relevant to the content of the whole file

* first headline

Now everything above the first heading ends inside the column outline_preamble of the table outlines. I would say the content before the first heading is "officialy" approved from the org-mode 9.6 and it is named as the level 0:

3.3.7. Property drawers allowed before first headline Property drawers are now allowed before the first headline. Org mode is moving more towards making things before the first headline behave just as if it was at outline level 0.

I have read your comment and I understand the reasoning related to finding the proper schema for properties on the top level. I think there are three ways of properties/attributes/metadata declaration on the level zero and they are not equivalent to my knowledge (Setting Properties for org-mode whole buffers).

--------------------------------------1st
#+title:      file title
#+filetags: tag1:tag2

--------------------------------------2nd
:PROPERTIES:
:YEAR: 2015        
:END:

--------------------------------------3rd
#+PROPERTY:  YEAR 2015

But it seems to me that the other content fits quite good as the level zero to the current schema of org-sql tables (at least that is my naive point of view). Hey I know it is not for free so the label 'feature request'.

My other argument is that it used to be quite a niche (to have content on the top level) but it seems to me there is a rising community of users around org-roam or denote who use it rudimentary (many small level zero like org-mode files rather than several files with dense headings). These are potential users of org-sql. I myself use both denote and the classical org style with headings.

Thanks for potentially considering this.