cross-posted from: https://programming.dev/post/252619

Works with Postgresql, MySql, and SQLite natively.

Extends confirmed support for DuckDB, ClickHouse, BigQuery, and Snowflake via the vdsql plugin.

Works with Postgresql, MySql, and SQLite natively.

Extends confirmed support for DuckDB, ClickHouse, BigQuery, and Snowflake via the vdsql plugin.

How to Play

• Select a player for each cell that matches the criteria for that cell's row and column

• For a player to be considered valid for a team, he must've played at least one game for that team at the MLB level

• If a cell is for a team and an award, the player you select must have won that award while on that team

• If a cell is for a team and a season stat, the player you select must have recorded that stat while on that team

• If you select a player for a cell with a rate stat (AVG, ERA, etc.), that player must've accumulated that stat in a completed season

Link to talk slides: vyruss.org/computing/slides/pgconfde2023_dont_do_this.pdf

Inspired by: "Don't Do This" on the Postgresql wiki

How to Play

• Select a player for each cell that matches the criteria for that cell's row and column

• For a player to be considered valid for a team, he must've played at least one game for that team at the MLB level

• If a cell is for a team and an award, the player you select must have won that award while on that team

• If a cell is for a team and a season stat, the player you select must have recorded that stat while on that team

• If you select a player for a cell with a rate stat (AVG, ERA, etc.), that player must've accumulated that stat in a completed season

Shamelessly cross-posting this ...