SQL cells outputting data frames fail to work in dependency tree

The community member is experiencing an issue where their SQL cells outputting a dataframe are not working properly after a kernel reset and full auto run, causing downstream execution issues. Even though the dataframe output cells were referenced by downstream cells, some of the downstream cells did not find the dataframe. To resolve this, the community member had to add an if not None statement before the downstream cells, which required converting other SQL cells to Python cells, which is not ideal. The community member would prefer to be able to create dataframes with SQL cells and have the downstream dependent cells execute at the right time.

In the comments, another community member suggests that SQL cells should be reactive, meaning a dataframe defined in them should trigger the execution of downstream cells. They consider this a bug if it's not working as expected, and ask the original poster to share a small notebook where they see the behavior not working, if possible.