pub async fn get_number_of_last_l1_batch_executed_on_eth(
        &mut self,
    ) -> DalResult<Option<L1BatchNumber>> {
        Ok(sqlx::query!(
            r#"
            SELECT
                number
            FROM
                l1_batches
            LEFT JOIN
                eth_txs_history AS execute_tx
                ON (l1_batches.eth_execute_tx_id = execute_tx.eth_tx_id)
            WHERE
                execute_tx.confirmed_at IS NOT NULL
            ORDER BY
                number DESC
            LIMIT
                1
            "#
        )
        .instrument("get_number_of_last_l1_batch_executed_on_eth")
        .fetch_optional(self.storage)
        .await?
        .map(|row| L1BatchNumber(row.number as u32)))
    }
Returns the number of the last L1 batch for which an Ethereum execute tx was sent and confirmed.
core/lib/dal/src/blocks_dal.rs