Allow SQL statement in "before" clause of extractors about deepdive HOT 4 CLOSED

Same as after script.

This would be so useful, since most before/after scripts are actually running one/multiple SQL queries.

from deepdive.

You can call "psql ${DBNAME} -c 'your query'". It's a workaround.

I'm not sure we can/want to allow both a script and a sql query with the same config directory. Perhaps we can have "before_sql" and "after_sql" ? The order should be well defined though (e.g., the script before the sql or viceversa)

from deepdive.

It's a pretty old issue, seems not critical but still somewhat useful.

Walkarounds can be having scripts to execute it (datastore-specific, a bit wordy), or using a sql_extractor (a bit wordy, hard to manage pipeline).

Not sure if we want to support in this version. Does anyone find it an urging need? We may have much easier "mindbender" syntax in the future.

from deepdive.

Not a priority. Marking as won't fix and closing.

from deepdive.