”Shir HaMa’alot” is Psalm 126. It is said before Birkat HaMazon on Shabbat and holidays. This text was under serious consideration to be the Israeli National Anthem before "Hatikvah" was chosen.
(א) שִׁ֗יר הַֽמַּ֫עֲל֥וֹת בְּשׁ֣וּב יהוה אֶת־שִׁיבַ֣ת צִיּ֑וֹן הָ֝יִ֗ינוּ כְּחֹלְמִֽים׃
(1) A song of ascents. When the LORD restores the fortunes of Zion —we see it as in a dream— [Alternative translations: When the LORD restored the captives of Zion, we were like dreamers. OR When the Lord brought back those that returned to Zion, we were like dreamers.]

(ב) אָ֤ז יִמָּלֵ֪א שְׂח֡וֹק פִּינוּ֮ וּלְשׁוֹנֵ֪נוּ רִ֫נָּ֥ה אָ֭ז יֹאמְר֣וּ בַגּוֹיִ֑ם הִגְדִּ֥יל יהוה לַעֲשׂ֥וֹת עִם־אֵֽלֶּה׃
(2) our mouths shall be filled with laughter, our tongues, with songs of joy. Then shall they say among the nations, “The LORD has done great things for them!” [Alternative translations have this in past tense]
(ג) הִגְדִּ֣יל יהוה לַעֲשׂ֥וֹת עִמָּ֗נוּ הָיִ֥ינוּ שְׂמֵחִֽים׃
(3) The LORD will do / did great things for us and we shall rejoice.
(ד) שׁוּבָ֣ה יהוה אֶת־שבותנו [שְׁבִיתֵ֑נוּ] כַּאֲפִיקִ֥ים בַּנֶּֽגֶב׃
(4) Restore our fortunes (OR Bring us back from our captivity), O LORD, like watercourses in the Negev.
(ה) הַזֹּרְעִ֥ים בְּדִמְעָ֗ה בְּרִנָּ֥ה יִקְצֹֽרוּ׃
(5) They who sow in tears shall reap with songs of joy.
(ו) הָ֘ל֤וֹךְ יֵלֵ֨ךְ ׀ וּבָכֹה֮ נֹשֵׂ֪א מֶֽשֶׁךְ־הַ֫זָּ֥רַע בֹּֽ֬א־יָב֥וֹא בְרִנָּ֑ה נֹ֝שֵׂ֗א אֲלֻמֹּתָֽיו׃
(6) Though he goes along weeping, carrying the seed-bag, he shall come back with songs of joy, carrying his sheaves.
This psalm also kicks off Birkat HaMazon on Shabbat and holidays. Here are some tunes for it.
Davening: A Guide to Meaningful Jewish Prayer, 2012, p. 39-40
אָמַר רַבִּי יוֹחָנָן: כׇּל יָמָיו שֶׁל אוֹתוֹ צַדִּיק, הָיָה מִצְטַעֵר עַל מִקְרָא זֶה: ״שִׁיר הַמַּעֲלוֹת בְּשׁוּב יהוה אֶת שִׁיבַת צִיּוֹן הָיִינוּ כְּחֹלְמִים״, אָמַר: מִי אִיכָּא דְּנָיֵים שִׁבְעִין שְׁנִין בְּחֶלְמָא? יוֹמָא חַד הֲוָה אָזֵל בְּאוֹרְחָא, חַזְיֵיהּ לְהָהוּא גַּבְרָא דַּהֲוָה נָטַע חָרוּבָא, אֲמַר לֵיהּ: הַאי, עַד כַּמָּה שְׁנִין טָעֵין? אֲמַר לֵיהּ: עַד שִׁבְעִין שְׁנִין. אֲמַר לֵיהּ: פְּשִׁיטָא לָךְ דְּחָיֵית שִׁבְעִין שְׁנִין? אֲמַר לֵיהּ הַאי גַּבְרָא: עָלְמָא בְּחָרוּבָא אַשְׁכַּחְתֵּיהּ. כִּי הֵיכִי דִּשְׁתַלוּ לִי אֲבָהָתִי — שְׁתַלִי נָמֵי לִבְרָאִי. יָתֵיב, קָא כָּרֵיךְ רִיפְתָּא, אֲתַאי לֵיהּ שִׁינְתָּא, נִים. אַהְדַּרָא לֵיהּ מְשּׁוּנִּיתָא, אִיכַּסִּי מֵעֵינָא, וְנִים שִׁבְעִין שְׁנִין. כִּי קָם, חַזְיֵיהּ לְהָהוּא גַּבְרָא דְּהוּא קָא מְלַקֵּט מִינַּיְיהוּ, אָמַר לֵיהּ: אַתְּ הוּא דִּשְׁתַלְתֵּיהּ? אֲמַר לֵיהּ: בַּר בְּרֵיהּ אֲנָא. אֲמַר לֵיהּ: שְׁמַע מִינַּהּ דִּנְיַימִי שִׁבְעִין שְׁנִין. חֲזָא לַחֲמָרְ[תֵּ]יהּ דְּאִתְיְילִידָא לַיהּ רַמְכֵי רַמְכֵי. אֲזַל לְבֵיתֵיהּ אֲמַר לְהוּ: בְּרֵיהּ דְּחוֹנִי הַמְעַגֵּל מִי קַיָּים? אֲמַרוּ לֵיהּ: בְּרֵיהּ לֵיתֵאּ, בַּר בְּרֵיהּ אִיתֵאּ. אֲמַר לְהוּ: אֲנָא חוֹנִי הַמְעַגֵּל. לָא הֵימְנוּהוּ. אֲזַל לְבֵית הַמִּדְרָשׁ, שַׁמְעִינְהוּ לְרַבָּנַן דְּקָאָמְרִי: נְהִירָן שְׁמַעְתָּתִין כְּבִשְׁנֵי חוֹנִי הַמְעַגֵּל, דְּכִי הָוֵי עָיֵיל לְבֵית מִדְרְשָׁא — כֹּל קוּשְׁיָא דַּהֲווֹ לְהוּ לְרַבָּנַן הֲוָה מְפָרֵק לְהוּ. אָמַר לְהוּ: אֲנָא נִיהוּ, וְלָא הֵימְנוּהוּ, וְלָא עָבְדִי לֵיהּ יְקָרָא כִּדְמִבְּעֵי לֵיהּ. חֲלַשׁ דַּעְתֵּיהּ, בְּעָא רַחֲמֵי, וּמִית. אָמַר רָבָא: הַיְינוּ דְּאָמְרִי אִינָשֵׁי: אוֹ חַבְרוּתָא אוֹ מִיתוּתָא.
§ The Gemara relates another story about Ḥoni HaMe’aggel. Rabbi Yoḥanan said: All the days of the life of that righteous man, Ḥoni, he was distressed over the meaning of this verse: “A song of Ascents: When the Lord brought back those who returned to Zion, we were like those who dream” (Psalms 126:1). He said to himself: Is there really a person who can sleep and dream for seventy years? How is it possible to compare the seventy-year exile in Babylonia to a dream? One day, he was walking along the road when he saw a certain man planting a carob tree. Ḥoni said to him: This tree, after how many years will it bear fruit? The man said to him: It will not produce fruit until seventy years have passed. Ḥoni said to him: Is it obvious to you that you will live seventy years, that you expect to benefit from this tree? He said to him: That man himself found a world full of carob trees. Just as my ancestors planted for me, I too am planting for my descendants. Ḥoni sat and ate bread. Sleep overcame him and he slept. A cliff formed around him, and he disappeared from sight and slept for seventy years. When he awoke, he saw a certain man gathering carobs from that tree. Ḥoni said to him: Are you the one who planted this tree? The man said to him: I am his son’s son. Ḥoni said to him: I can learn from this that I have slept for seventy years, and indeed he saw that his donkey had sired several herds during those many years. Ḥoni went home and said to the members of the household: Is the son of Ḥoni HaMe’aggel alive? They said to him: His son is no longer with us, but his son’s son is alive. He said to them: I am Ḥoni HaMe’aggel. They did not believe him. He went to the study hall, where he heard the Sages say about one scholar: His halakhot are as enlightening and as clear as in the years of Ḥoni HaMe’aggel, for when Ḥoni HaMe’aggel would enter the study hall he would resolve for the Sages any difficulty they had. Ḥoni said to them: I am he, but they did not believe him and did not pay him proper respect. Ḥoni became very upset, prayed for mercy, and died. Rava said: This explains the folk saying that people say: Either friendship or death, as one who has no friends is better off dead.


