content: import pandas as pd
  
  from fireant.dataset.fields import Field
  from fireant.utils import (
      alias_for_alias_selector,
      immutable,
  )
  from fireant.queries.builder.query_builder import QueryBuilder, QueryException, add_hints
  from fireant.queries.execution import fetch_data
  
  
  class DimensionLatestQueryBuilder(QueryBuilder):
      def __init__(self, dataset):
          super().__init__(dataset)
  
      @immutable
      def __call__(self, dimension: Field, *dimensions: Field):
          self._dimensions += [dimension] + list(dimensions)
  
      @property
      def sql(self):
          """
          Serializes this query builder as a set of SQL queries.  This method will always return a list of one
          query since only one query is required to retrieve dimension choices.
  
          This function only handles dimensions (select+group by) and filtering (where/having), which is everything
          needed for the query to fetch choices for dimensions.
  
          The dataset query extends this with metrics, references, and totals.
          """
          if not self.dimensions:
              raise QueryException("Must select at least one dimension to query latest values")
  
          query = self.dataset.database.make_latest_query(
              base_table=self.table,
              joins=self.dataset.joins,
              dimensions=self.dimensions,
          )
          return [query]
  
      def fetch(self, hint=None):
          queries = add_hints(self.sql, hint)
          max_rows_returned, data = fetch_data(self.dataset.database, queries, self.dimensions)
          data = self._get_latest_data_from_df(data)
          return self._transform_for_return(data, max_rows_returned=max_rows_returned)
  
      def _get_latest_data_from_df(self, df: pd.DataFrame) -> pd.Series:
          latest = df.reset_index().iloc[0]
          # Remove the row index as the name and trim the special dimension key characters from the dimension key
          latest.name = None
          latest.index = [alias_for_alias_selector(alias) for alias in latest.index]
          return latest
  