Concept for Vasopressor Durations

[ajb5d]

I'd like to contribute a materialized view for vasopressor durations (similar to the MIMIC tables). What is the preferred 'dialect' of SQL? BigQuery or Postgres? The syntax for casting is different between the two.

[tompollard]

@ajb5d Thanks for the message, and good question! Either/both would be appreciated. We're using BigQuery a lot at the moment, especially at datathons, so a BigQuery version would definitely get some use.

We don't have a good system for managing different dialects of SQL, so we'd welcome your suggestions for this. With MIMIC we have ended up with two separate branches (google-cloud-views for BigQuery and master for Postgres), which isn't ideal.

[ajb5d]

Would it be reasonable make a directory for each dialect and keep them on the same branch?

Also, Are you opposed to a Postgres user-defined function? I'm having trouble finding an elegant way to cast a string to integer in a "safe" way.

[tompollard]

Would it be reasonable make a directory for each dialect and keep them on the same branch?

I think this probably easier to navigate than separate branches, so sounds good to me.

Also, Are you opposed to a Postgres user-defined function? I'm having trouble finding an elegant way to cast a string to integer in a "safe" way.

Also sounds good to me!

[alistairewj]

Sorry I haven't reviewed the PR yet, but hopefully I will find time to soon!