Closes #2879

The approach is to let the compiler only process the chars required to understand a partition dir name, while ignoring the rest, for each of the items in the comma separated list following the LIST token.

Example, for a table partitioned by month:

alter table x drop partition list '2023-03-29T23', ... ;

2023-03-29T23 is a valid partition name now for month granularity because the compiler knows that the patter for partition by month is yyyy-MM, which means it can parse a date up to month, thus -29T23 is ignored. Incidentally, this would work too alter table x drop partition list '2023-03-a-banana' ;. We are trying to make life easier for users who might use a full timestamp (select max(ts) from table) to drop a partition (the last one in this example).

WHERE is not supported, no value, and harder a problem to solve.

The case of partition by week is complicated. We first try to parse the partition name candidate with format YYYY-Www, and if it fails we assume the user sent a string that looks more like a date, or a timestamp, and we parse it with the day pattern yyyy-MM-dd, then we translate it to the timestamp of the day the week starts at.