DuneSQL intervals only support 'day' and seem to not support 'week' or 'month' (i.e. interval '1' week) https://trino.io/docs/current/functions/datetime.html#interval-functions

When I run a query more than once, I get different results in this query. Moreover, I do not change the request, I run the same one. https://dune.com/queries/1686953

Would be great if the Solana DB had access to dune_user_generated similar to ETH DB

When you search something in the V2 search bar, the returns results based on the aliases of the data tables. e.g: if you type "erc20 transfer" you will get the result, but if you type in "transfers_ethereum.erc20" which is the exact name of the table as used in the query the search bar returns nothing. This is annoying when navigating the indexed databases as I remember the tables that I use by their proper names and not aliases. This is especially tricky for decoded functions which can have lengthy names which the alias does not reflect.

(Not Only V2) Need to fix for duplicate contracts for ethereum.contract .

In Dune v2.0, a lot of abstractions now use string instead of Bytea. In SQL strings are case sensitive, so I have to format every single txhash, and address that I use because the data tables are strings now instead of bytea.

Currently, the MEV data tables from flashbots only support until pre-merge (15 Sep)

opensea v2 was not detected

Duplicate erc721, ERC721 in token_standard column in nft.trades.

Something like labels.get(...) would be amazing. Or have the full labels table available in v2 so we can join it in queries.